I gave that a shot last night, to no avail... It just doesnt seem to like
the pound sign(#) in the sql query. I'm trying to get the new db guy to
change the field name, but it's going to take a while, so i'd like to create
a workaround..
-----Original Message-----
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 01, 2000 12:04 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Escaping Pound Signs in a CF Query....
Yes. Either change it Cust ## or something else like Cust num. This also
applies to using the hex colour codes - eg: ##ff0000 intead of the usual
#ff0000 - within CFOUTPUT. The double pound signs cancel out the usual
CFOUTPUT requirement.
Peter Tilbrook
Internet Applications Developer
Aspect Computing Pty. Ltd.
19-25 Moore Street
Turner, ACT, 2612
AUSTRALIA
http://www.aspect.com.au
Phone: (02) 6247 7677
Fax: (02) 6249 1620
Mobile: 0428 765 020
ACT ColdFusion Users Group - http://203.37.24.198
-----Original Message-----
From: Mark Armendariz [mailto:[EMAIL PROTECTED]]
Sent: Friday, 1 September 2000 5:00
To: Cf-Talk
Subject: Escaping Pound Signs in a CF Query....
For some strange and utterly inconvenient reason, our former Access Database
guy had created a form field named Cust#. I imagine this stands for
CustNumber, but CF doesn't seem to agree. Is there a way to escape a #
(pound sign) so i can query the table?
I've tried doing a "Cust# As CustNum" as well as Cust##. Nothing seems to
work.
Anyone know of anything?
Thanks In Advance!!
Mark Armendariz
Righteous Design
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.