Use preserveSingleQuotes() (I wonder how many identical answers we'll get for this frequently asked chestnut? :)
On Friday, Dec 13, 2002, at 09:29 US/Pacific, Wurst, Keith D. wrote: > 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 Get the mailserver that powers this list at http://www.coolfusion.com