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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
