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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.