You can always go back and smack the DB creator
Not a solution, but may lower the stress level :o)
but seriously, if the person that created the DB is still around, I hope
someone explained to him, that you should NEVER put special chars in column
names.
-----Original Message-----
From: Howarth, Craig (IBK-NY) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 9:41 AM
To: CF-Talk
Subject: RE: Column names containing a # sign
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
