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
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
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
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
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
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
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
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
> >
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
* 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
[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
I'm trying to do a simple update to an access database using the ADOdb
library. For some reason I can't get it to work. I can however, get a
simple select statment to work just fine. Take a look at my code below
as well as the error message. Maybe someone can help me out. As you'll
see bel
12 matches
Mail list logo
