PHP MS-Access odbc_exec() gives 'too few parameters' error

JoeNinja

Im failing to update the an MS ACcess. I will appreciate Your advice. I get the error below

Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect in C:\Program Files\Apache Group\Apache2\htdocs\Test\Thomas\HelpDesk\UpdateAs sign.php on line 27

Here is the script that is generating the error.

Expand|Select|Wrap|Line Numbers

 
<?php
 
$conn=odbc_connect("HELPDESK","" ,"");
 
     $surname = $_POST['SurNametxt'];

     $firstname = $_POST['firsNametxt'];

     $station = $_POST['Stationtxt'];

     $jobtitle = $_POST['JobTitletxt'];

     $datelogged = $_POST['DateLogtxt'];

     $complaint = $_POST['compl'];

     $status = 'A'; 

     $priority = $_POST['Priortxt'];

     $technician = $_POST['Techtxt'];

     $priority  = "$priority";
 
if (!$conn)

       {exit("Connection Failed: " .$conn);}
 
$update = "update hdsk_complain

SET  hd_com_priority = $priority

Where hd_com_jobtitle= 'SDM'";
 
$result = odbc_exec($conn, $update);
 
if (!$result) {exit('Execution failed!');} 
 
     odbc_close($conn);

?>

pbmods

Heya, Joe. Welcome to TSDN!

Please use CODE tags when posting source code. See the REPLY GUIDELINES on the right side of the page next time you post.

Changed thread title to better describe the problem (did you know that threads whose titles contain phrases such as, 'problem' actually get FEWER responses?).

code green

Quote:

Too few parameters. Expected 1

Using ODBC this usually means you have an incorrect field name.
I am not saying this is a definition of the error.
Just that in my experience this is the problem.
So the problem may be your query

Expand|Select|Wrap|Line Numbers

 update hdsk_complain

SET  hd_com_priority = $priority

Where hd_com_jobtitle= 'SDM'";

PHP MS-Access odbc_exec() gives 'too few parameters' error

re: PHP MS-Access odbc_exec() gives 'too few parameters' error

re: PHP MS-Access odbc_exec() gives 'too few parameters' error

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about