RE: [PHP] Column name not liked by PHP/ODBC and Access

mweb, Just a guess - is Note a reserved word? you might want to quote/escape it. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: mweb [mailto:mweb@inwind.it] > Sent: Tuesday, December 04, 2001 4:53 PM > To: php-general@lists.php.net > Subject: [PHP] Column name not liked by PHP/ODBC and Access > > > Hello, > > still fighting to drive MS access from PHP, I have come into an > error when I > feed odbc_exec with this statement (db connection is fine now): > > INSERT INTO Redazione (ID, Name, Nickname, Username, password, > From, Note, > amministratore, playlist, email, > role, web) VALUES (NULL , "me", "webmin", "webber", > "12321", "0", > "", "on", > "on", "e2e2e", "222e", "www.test.com"); > > > Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] > Syntax error in > INSERT INTO statement., SQL state > 37000 in SQLExecDirect in C:\domini\m.net\cng_red.php on line 71 > Error(no cursor odbc_exec) > > The weird thing is that I this syntax error ONLY if I write "Note in the > columns list. If I omit it, or even change to not existing column > name (like > "note_fake" for example, no errors are reported. If I omit it I get just > complaints that there are not enough fields, but no errors. Also, > it couldn't > care less what I put as the Note field value ("" in the case above). > > Ideas? > Mweb > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >