Column name not liked by PHP/ODBC and Access
| From: | mweb | 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