Re: ADOdb SQL Updates
| From: | John W. Holmes | Date: | Tue, 20 Apr 2004 21:15:01 +0000 |
| Subject: | Re: ADOdb SQL Updates | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-184058@lists.php.net to get a copy of this message | ||
From: "Gabe" <ydnahg-news4432@mailblocks.com>
> 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...