Try using the PreserveSingleQuotes function. ----- Original Message ----- From: "Wurst, Keith D." <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, December 13, 2002 11:29 AM Subject: Problem with single quotes
> Hi everyone. I'm having a problem with single quotes. I'm building the > "where" part of a sql statement dynamically. So, I have a variable called > where_query. When I display where_query on the page I see: > > where ( title like '%Cancer%') or (duration_start >= '1/13/2002') or > (amount_requested > 5000) > > But when I then put it into a sql statement it looks like this > > where ( title like ''%Cancer%'') or (duration_start >= ''1/13/2002'') or > (amount_requested > 5000) > > Does anyone know where those extra single quotes came from? Anyone know how > I might be able to get rid of them? Thanks very much. > Keith > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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