Column name not liked by PHP/ODBC and Access

From: Date: Tue, 04 Dec 2001 21:52:57 +0000
Subject: Column name not liked by PHP/ODBC and Access
Groups: php.general 
Request: Send a blank email to php-general+get-76603@lists.php.net to get a copy of this message
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

« previous php.general (#76603) next »