Here's another version of the SQL statement and I get a different error now. When I copy and paste this exact same SQL statement into an update query in Access it works fine. When I try to use it in my PHP code, I get the following error:
SQL Statement: UPDATE tblFAQ_Book SET fldTitle = 'one more test' WHERE (autoBookID= 1);
Error Message: Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in d:\adodb\drivers\adodb-odbc.inc.php on line 504 S1000: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
Thanks
Curt Zirzow wrote:
* Thus wrote Gabe ([EMAIL PROTECTED]):
...
(access): UPDATE tblFAQ_Book SET tblFAQ_Book.fldTitle = "one more test" WHERE (tblFAQ_Book.autoBookID = 1)
Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect in \adodb\drivers\adodb-odbc.inc.php on line 504
07001: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Recheck the spelling of column names and table names.
Curt
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php