have you tried doubling your #
ie product# = product## etc - cf should convert that to a single # before
passing to db...
-----Original Message-----
From: Tristram Charnley [mailto:[EMAIL PROTECTED]]
Sent: 10 July 2001 17:18
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
