Try replacing the single # with a double # in the column name...
i.e. field#name would be field##name in your CFQuery block.
> -----Original Message-----
> From: Tristram Charnley [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 10, 2001 11:18 AM
> 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
