Where are you using the PreserveSingleQuotes()? It's always worked
for me, and your SQL string doesn't have anything unusual in it.
What exactly did the hotfix do for you?
>Nope, that doesn't work. Actually, I just found a hotfix in a technote:
~~
Are you *sure* PreservereSingleQuotes() doesn't work?
This works fine:
#PreserveSingleQuotes(myQry)#
I'd guess you're over escaping them somewhere along the line...
Bert
On Thu, 3 Feb 2005 13:39:24 -0500, Burns, John D
<[EMAIL PROTECTED]> wrote:
> I'm going crazy here because I can't f
ailto:[EMAIL PROTECTED]
Sent: Thursday, February 03, 2005 1:12 PM
To: CF-Talk
Subject: Re: Dynamic Query Problem
Use #PreserveSingleQuotes(yourSQL)#
~|
Find out how CFTicket can increase your company's customer support
Use #PreserveSingleQuotes(yourSQL)#
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for f
OK Don't all rush - Solved it myself:
#Evaluate(DE(ColData))#
Tristram Charnley
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-t
5 matches
Mail list logo