Try tripleing your # signs. I know this sounds crazy, but had a similar
instance and table_Name### worked like a charm.
CW
-----Original Message-----
From: Michael Lugassy [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 12:50 PM
To: CF-Talk
Subject: Re: Column names containing a # sign
Try calling the "#" with its respectebly chr(num)
I don't know which asacii code is "#" but try this (although it may sounds
silly):
(let's say the 19 ASCII code is "#")...
UPDATE Registration#chr(19)#
SET ..... bla bla bla
It might help because I've seen cases where the char itself and the
chr(ASCII_char_num) performed diffrently.
Michael.
----- Original Message -----
From: "Daniel Lancelot" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, July 10, 2001 9:31 PM
Subject: RE: Column names containing a # sign
> 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
