RE: Help with single quote in QofQ

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=qSELECT * FROM qDave WHERE mystring = '#sSearchString#'/cfquery cfdump var=#q# Your

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

RE: Help with single quote in QofQ

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

RE: Help with single quote in QofQ

Dave, I just ran this and it worked fine. I am on CFMX 7. What version are you running? Did you try using CFQueryParam for the value? .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original

Re: Help with single quote in QofQ

cfqueryparam? 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,

RE: Help with single quote in QofQ

: Help with single quote in QofQ Dave, I just ran this and it worked fine. I am on CFMX 7. What version are you running? Did you try using CFQueryParam for the value? ... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help