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
I'm going crazy here because I can't figure out why this is acting this
way.
We've got some code in a CFSCRIPT block that builds some SQL to be
executed in a query. The variable holds a value that looks like this:
insert into table(id,value1,value2,value3) values(9,'First Name', 'Last
Name','1
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
Hi All
I'm building a dynamic query that will export to an Excel
spreadsheet. The client can choose from a list of fields
to export so the query is built dynamically and the column names
in the SELECT statement are built from a list submitted in
a form field. The query works fine.
Next I've got
7 matches
Mail list logo