Re: ADOdb SQL Updates

At 11:01 AM 4/21/2004, you wrote:

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.

this sounds like your are updating the table with exactly the same values that are already present? Have you tried it on different values to see if it works or just the ones you paste into access? -Dave

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

-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

David G. O'Brien Web Services Coordinator / Systems Administrator NACCRRA The Nation's Network of Child Care Resource & Referral 1319 F Street NW, Suite 500 Washington, DC 20004 (202) 393-5501 ext. 113 (202) 393-1109 fax