Wurst, Keith D. wrote: > Hey everyone. I wanted to include some single quotes into a cfset so that I > can use the variable in a sql query. Any suggestions on how to do this? > > For example... > > <cfset cip_numb = "cip = #get_cip_num.cip_number#"> > > I would like to put the single quotes around the #get_cip_num.cip_number#. > Thanks for the help.
Keith, We just had a lovely discussion on the use of the <CFQUERYPARAM> tag... which I would recommend you use.. it'll solve any and all issues related to single quotes in your queries. - Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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.
