thanks -----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Monday, November 08, 2004 11:18 AM To: CF-Talk Subject: Re: MySql and reserved words.
Eric Creese wrote: > I converted over an Access database to MySql. Problem is one of my columns is > a reserved word in MySql (lines). I would like to change the code around > (lines) so I do not have to modify the schema and the code, I just want to > modify the code if possible. Can you put a some characters around the > reserved word so you can use it or not? Use double quotes (preferable) if you are running in ANSI mode or else use backticks. > In SQl you could use [lines] though lines is not a reserved word in SQL. In SQL you would use "lines". [lines] is something some vendor invented which is just as broken as the `lines` some other vendor invented. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183637 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
