Jump to content

oops

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

oops's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I am using this new oledb extension for creating a prepared statement..with following lines of code...       $oConRef= oledb_connect($Host,$DBUserName,$DBPassword); $oConRef= oledb_select_db($DBName,$oConRef);         $statement=oledb_prepare("Update table XUSER where user_type=?");     oledb_bind($statement,'@user_type',$user_type,OLEDB_VARCHAR);     $rdxdata=oledb_execute($statement);       while($row = oledb_fetch_array($rdxdata))       {           $dd=$row['user_type'];         echo "\n".$dd;       } is showing following error if i am going for a bind statement... [b]Warning: oledb_bind() [function.oledb-bind]: Unsupported type  [/b] could u plz correct me where m wrong. Is there any syntax error which is creating problem..if so then what will be the correct code for this./. I want to prepare a prepared statement for my query which is being called for diffent user types...at different- different places.so i need to bind different values for "user type " with the same query. i am using PHP 5.0,MS SQL 2000 and oledb combination. plz help  me out...its quite urgent. thanks, oops
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.