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

2001-12-05 Thread Brinkman, Theodore
[mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 04, 2001 5:53 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Column name not liked by PHP/ODBC and Access You could just rename the column in the db. Putting quotes around Note is not the solution because the quotes are causing

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

2001-12-04 Thread Jim
You could just rename the column in the db. Putting quotes around Note is not the solution because the quotes are causing the invalid name error. I don't see that Note is a reserved word anywhere. Access is quite picky about what data you send it. For instance, if a field is set to require so

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

2001-12-04 Thread mweb
On Tuesday 04 December 2001 23:25, Jim wrote: > I've searched high and low for _good_ PHP/MSACCESS info, but the fact > is not that many people use it. I know. It's not my choice, believe me.. :-(( > What I've found very helpful is to use MS ACCESS' SQL builder to test > out my queries. Fair

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

2001-12-04 Thread Jim
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

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

2001-12-04 Thread mweb
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

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

2001-12-04 Thread Andrew Hill
From: mweb [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 04, 2001 4:53 PM > To: [EMAIL PROTECTED] > 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 >

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

2001-12-04 Thread mweb
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", "webmi