> -----Original Message----- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 4:49 PM > To: CF-Talk > Subject: Re: unexpeted result with cfqueryparam > > > Andrew Tyrone wrote: > > > > If it's a bug, it's been there since CF 4.0 at least, which is > the version I > > started with. Like I said in my first response, it makes sense > to me that > > CF doesn't escape the single quotes when you are running other > functions on > > the value. > > It doesn't? How do you explain the doubling of the quotes when using > cfqueryparam then? > > Jochem
I was talking about running functions on the value, not about using cfqueryparam. I haven't tested with adding functions inside the value attribute to the variable of cfqueryparam. I was just offering the observation that I've noticed the behavior of cfquery in general is that it doesn't escape single quotes if you use functions on the value you are passing in inside the query. I tend to do all the processing on my variables outside of cfquery/cfstoredproc. --Andy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4