No, it's not converting them to double quotes, it's escaping each single quote in the string -- the default for <cfquery> -- you have to use #PreserveSingleQuotes()# around your variable if you want to use a variable which contains a block of sql code containing quoted variables.
> 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
