I've searched high and low for _good_ PHP/MSACCESS info, but the fact is not that many people use it.
What I've found very helpful is to use MS ACCESS' SQL builder to test out my queries. Fairly reliably, if it works there, it'll work in PHP. Jim >On Tuesday 04 December 2001 22:47, Andrew Hill wrote: >> mweb, >> >> Just a guess - is Note a reserved word? you might want to quote/escape it. > >Excellent idea. Actually, putting Note between double quotes gives: >INSERT INTO Red (ID, Nome, Nickname, Username, password, pict, "Note", >admin, playlist, email, ruolo, web) VALUES (NULL , "mweb", "webfm", >"webfm1", "12321", "0", "", "on", "on", "e2e2e", "222e", "www.ni.it"); > > >Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] '' is not a >valid name. Make sure that it does not include invalid characters or >punctuation and that it is not >too long., SQL state 37000 in SQLExecDirect in >C:\domini\musicboom.net\cng_red.php on line 71 >Error(no cursor odbc_exec) > > How else could I escape Note, and what this last message means? > >In general do you know about *detailed* tutorial for MS access via odbc? > > TIA, > mweb > >P.S.: special thanks to Andrew Hill who is always very fast and patient in his >answers > >-- >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] -- Jim Musil --------- Multimedia Programmer Nettmedia ------------- 212-629-0004 [EMAIL PROTECTED] -- 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]