> -----Original Message----- > From: Jochem van Dieten [mailto:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 4:20 PM > To: CF-Talk > Subject: Re: unexpeted result with cfqueryparam > > > Dina Hess wrote: > > > > I agree that Trim() should not influence a single quote. Nor should > > HTMLEditFormat(). But both do, even without CFQUERYPARAM. > > > > Why?
> > Bug. > > Jochem 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's almost as if CF is saying "Since you are adding additional processing to the variable, I'm not touching it in case my automatic escaping of single quotes messes up what you intended to do to the variable inside the query." --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 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
