Re: Columns named with the # character

2001-03-16 Thread Fred van Engen
Erling and MySQL guys, On Fri, Mar 16, 2001 at 02:18:55AM +0100, Erling Paulsen wrote: I just exported (via myodbc) an old access database for my sportsclub to mysql (the tables). The ms-access database application still works nicely on the new linked tables in mysql. However, I'm now also

Re: Columns named with the # character

2001-03-16 Thread Fred van Engen
On Fri, Mar 16, 2001 at 10:33:05AM +0100, Fred van Engen wrote: The mysql client doesn't know about backticks and therefore handles the # (and '-- ') as the beginning of a comment. It wouldn't do that for quoted and double-quoted strings. I see no workaround other than to change the

Columns named with the # character

2001-03-15 Thread Erling Paulsen
I just exported (via myodbc) an old access database for my sportsclub to mysql (the tables). The ms-access database application still works nicely on the new linked tables in mysql. However, I'm now also writing a php based client to use the database over the web and the problem is as follows:

Re: Columns named with the # character

2001-03-15 Thread Paul DuBois
At 2:18 AM +0100 3/16/01, Erling Paulsen wrote: I just exported (via myodbc) an old access database for my sportsclub to mysql (the tables). The ms-access database application still works nicely on the new linked tables in mysql. However, I'm now also writing a php based client to use the

Re: Columns named with the # character

2001-03-15 Thread Erling Paulsen
tables: 1 Open tables: 19 Queries per second avg: 0.017 -- - Original Message - From: "Sam Smith" [EMAIL PROTECTED] To: "Erling Paulsen" [EMAIL PROTECTED] Sent: Friday, March 16, 2001 3:21 AM Subject: Re: Columns named with the # character On Fri, 16 Mar