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

Reply via email to