Dynamic Query Problem

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

Re: Dynamic Query Problem

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

RE: Dynamic Query Problem

:[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 efficiency

Re: Dynamic Query Problem

Are you *sure* PreservereSingleQuotes() doesn't work? This works fine: cfset myQry = select 'hello' cfquery name=q datasource=#request.dsn# #PreserveSingleQuotes(myQry)# /cfquery I'd guess you're over escaping them somewhere along the line... Bert On Thu, 3 Feb 2005 13:39:24 -0500,

Re: Dynamic Query Problem

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:

Dynamic query problem

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

RE: Dynamic query problem

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: