@ Anyone building dynamic queries: PLEASE **DO NOT** follow that advice. You will regret it, eventually. If the data you're dealing with is sensitive enough, you might even go to prison over it.
The proper solution is the one already mentioned by Steve and Bill. Build the statement - with <cfqueryparam> - inside of the <cfquery> block. On Tue, Jan 22, 2013 at 4:10 PM, <> wrote: > > You need to use the preserveSingleQuotes () pseudo function ie: > > <cfquery name="foo"> > #preserveSingleQuotes(sqlStatement)# > </cfquery> > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354012 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm