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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
