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
--
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:
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
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
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.
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
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
[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
* 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
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
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
11 matches
Mail list logo