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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
