ODBC Microsoft Access 97 Driver SQLExecDirect

[Michael Taouk]

I am using the "odbc_exec" function in php to update data
in a Microsoft Access 97 database, as follows:

$sqlUpdate = 'UPDATE tblFactoryItems SET comments ="'.
$_POST['comment'] . '" WHERE ItemID=1';
odbc_exec($cnx, $sqlUpdate);

I get an error:
Warning: SQL error: [Microsoft][ODBC Microsoft Access 97
Driver] Too few parameters. Expected 1., SQL state 07001
in SQLExecDirect

Where can I get info about 'SQLExecDirect' so that I can
debug the code?

 

[BJ Freeman]

http://www.odbcrouter.com/api/SQLExecDirect.shtml

 

[BJ Freeman]

also went to http://support.microsoft.com/
and did a search on SQLExecDirect.
came back with lots of info.

 

[BJ Freeman]

and one more:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/od
ch21epr.asp