How about square brackets?
Nick
-----Original Message-----
From: Richard Kern [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 09, 2001 12:29 AM
To: CF-Talk
Subject: SQL syntax for contol characters
A question for you.
I have inherited an access db upsized to SQL7 that has some nasty column
names, obviously won't ouput in CF without an alias. However is formating
the SQL statement using a single quote returns the literal string within the
quote and using a backtick to set it off generates an error in CF. So how
does one specify the target column name for an alias?
ex
SELECT `home phone` AS PHONE
FROM EMPLOYEE
or
SELECT `TBR@40` AS TBR
FROM EMPLOYEE
produce a syntax error and
SELECT 'home phone' AS PHONE
FROM EMPLOYEE
produces 'home phone' in the field instead of the number
Thanks
Richard kern
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
