Ah- you are passing it to SQL? Can you show us all of your code? ======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire
Email : [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Wurst, Keith D. [mailto:wurst@;rti.org] > Sent: Tuesday, November 12, 2002 2:55 PM > To: CF-Talk > Subject: RE: Single quotes trouble... > > > I've tried that and it's showing up as double quotes - > causing the sql query > to fail. > > -----Original Message----- > From: Scott Brady [mailto:cf_talk@;scottbrady.net] > Sent: Tuesday, November 12, 2002 2:50 PM > To: CF-Talk > Subject: Re: Single quotes trouble... > > > ><cfset cip_numb = "cip = #get_cip_num.cip_number#"> > > > >I would like to put the single quotes around the > >#get_cip_num.cip_number#. > > If I understand the question, have you tried: > > <cfset cip_numb = "cip = '#get_cip_num.cip_number#'"> > > ? > > Scott > > -------------------------------- > Scott Brady > http://www.scottbrady.net/ > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
