Re: [PHP] ADOdb SQL Updates
Gabe wrote: I double checked the names. Everything looks okay. Another ideas? Did the ADOdb list answer not work? http://phplens.com/lens/lensforum/msgs.php?id=9285 Single and double quotes can be a problem in SQL. -- Lester Caine - L.S.Caine Electronic Services -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ADOdb SQL Updates
It sort of did. It may have corrected that error, but now I get a new error: 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. What do you think? Lester Caine wrote: Gabe wrote: I double checked the names. Everything looks okay. Another ideas? Did the ADOdb list answer not work? http://phplens.com/lens/lensforum/msgs.php?id=9285 Single and double quotes can be a problem in SQL. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ADOdb SQL Updates
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
Re: [PHP] 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 ([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 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ADOdb SQL Updates
After googling the error message for you, I found about a zillion pages which all basically say the same thing. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q175168 -Dave At 11:01 AM 4/21/2004, Gabe 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. 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 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ADOdb SQL Updates
Thanks Dave. It's working now. I searched many different places for an answer and yet for whatever reason, I just didn't check Google. We're all allowed a few brain mishaps, right? :-) Thanks again. David O'Brien wrote: After googling the error message for you, I found about a zillion pages which all basically say the same thing. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q175168 -Dave At 11:01 AM 4/21/2004, Gabe 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. 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 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ADOdb SQL Updates
Gabe wrote: It sort of did. It may have corrected that error, but now I get a new error: 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. What do you think? I see you have solved this - I only use Access when I'm moving customers problems away from it :) -- Lester Caine - L.S.Caine Electronic Services -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] ADOdb SQL Updates
[snip] I'm trying to do a simple update to an access database using the ADOdb library. Any help is much appreciated! [/snip] What error message are you getting? You are outputting an error message when queries fail, aren't you? Does the connected user have permission to perform updates on the specified table? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ADOdb SQL Updates
* 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 -- I used to think I was indecisive, but now I'm not so sure. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ADOdb SQL Updates
I double checked the names. Everything looks okay. Another ideas? 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
Re: [PHP] ADOdb SQL Updates
From: Gabe [EMAIL PROTECTED] I double checked the names. Everything looks okay. Another ideas? (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. What if you just tried the following query: UPDATE tblFAQ_Book SET fldTitle = one more test WHERE autoBookID = 1 Does access really need the tablename.column name syntax? ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php