Yes, I even mentioned that I tried that in my explanation. "I've tried using preserveSingleQuotes() around the value"
Dave -----Original Message----- From: Coldfusion [mailto:[EMAIL PROTECTED] Sent: Monday, February 19, 2007 11:56 AM To: CF-Talk Subject: RE: Help with single quote in QofQ Did you try: PreserveSingleQuotes() -----Original Message----- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, February 19, 2007 12:50 PM To: CF-Talk Subject: Help with single quote in QofQ Hi, I have a query on which I'm doing a query of queries to find specific values. One of my values has a single quote in it. When I dump the query, I can see the value with the single quote. But when I do a Q of Q on it to find the specific record based on a string comparison, I get zero results. I've tried using preserveSingleQuotes() around the value, and even tried replacing the value's single quote with two single quotes, but I can't find the right combination to get it to work. Either I get zero results, or a ColdFusion "error executing database query" (query of queries syntax error) which is actually kind of funny since it's not really a database query anyway. But that's beside the point. Anyway, here is my sample code to show you what's happening. If anyone can figure this one out, I would greatly appreciate it. I must be "forgetting" something simple! <cfset qDave = queryNew("mystring")> <cfset queryAddRow(qDave)> <cfset querySetCell(qDave,"mystring","This is Dave's test.")> <cfset sSearchString = "This is Dave's test."> <cfdump var="#qDave#"> <cfquery dbtype="query" name="q"> SELECT * FROM qDave WHERE mystring = '#sSearchString#' </cfquery> <cfdump var="#q#"> TIA! Dave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270114 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
