Two solutions:
1) Try escaping the names, as in Product##, in the CFQUERY and use a alias
<CFQUERY ...>
SELECT Product## AS ProductNum
FROM whatever
</CFQUERY>
2) Create a view on your database server that assigns an alias to each offending
column. Always access the table through the view.
Craig
> -----Original Message-----
> From: Tristram Charnley [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, July 10, 2001 12:18 PM
> To: CF-Talk
> Subject: Column names containing a # sign
>
> Hi
>
> I've been given a database containing column names such as
> Product# and Registration#
>
> I've tried using aliases and backticks on these columns in my query to
> no effect - the # sign throws CF each time. Changing the column names
> isn't an option unfortunately.
>
> Any suggestions greatfully received.
>
> Tristram Charnley
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
