Re: ADOdb SQL Updates
| From: | Gabe | Date: | Wed, 21 Apr 2004 15:01:33 +0000 |
| Subject: | Re: ADOdb SQL Updates | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-184136@lists.php.net to get a copy of this message | ||
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 (ydnahg-news4432@mailblocks.com):... (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