Re: [PHP] ADOdb SQL Updates

2004-04-21 Thread Lester Caine
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 S100

Re: [PHP] ADOdb SQL Updates

2004-04-21 Thread Gabe
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 pag

Re: [PHP] ADOdb SQL Updates

2004-04-21 Thread David O'Brien
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. W

Re: [PHP] ADOdb SQL Updates

2004-04-21 Thread David O'Brien
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 t

Re: [PHP] ADOdb SQL Updates

2004-04-21 Thread Gabe
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 mor

Re: [PHP] ADOdb SQL Updates

2004-04-21 Thread Gabe
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

Re: [PHP] ADOdb SQL Updates

2004-04-21 Thread Lester Caine
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 -- P

Re: [PHP] ADOdb SQL Updates

2004-04-20 Thread John W. Holmes
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 > >

Re: [PHP] ADOdb SQL Updates

2004-04-20 Thread Gabe
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 Microsof

Re: [PHP] ADOdb SQL Updates

2004-04-20 Thread Curt Zirzow
* 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 > SQLE

RE: [PHP] ADOdb SQL Updates

2004-04-20 Thread Jay Blanchard
[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 sp