Setting a SQL Statement as a Variable and Running UsingCFQuery

[ryanstewart]

I've got a table with a bunch of sql statements that I need to run and cfdump
the results to the screen. I have one <cfquery> tag that pulls the sql
statement out of the database based on an ID number given: <cfquery
name='retrieveSqlStatementToRun'> SELECT sql_statement as sqlData FROM Table1
WHERE statement_id = #sqlID# </cfquery> This works fine, and when I <cfdump>
or <cfoutput> the variable #retrieveSqlStatementToRun.sqlID# I see the SQL
statement I want to run: SELECT First_Name, Last_Name, Birthday FROM Table2
WHERE Last_Name = 'Smith' But when I set up the second <cfquery>, using only
the #retrieveSqlStatementToRun.sqlID# it gives me an 'Error Executing Database
Query' Here's the code for the second query: <cfquery name='runSqlStatement'>
#retrieveSqlStatementToRun.sqlData# </cfquery> Is there anything special I
need to do to run an entire SQL statment (the selects, from, and where) via one
Cold Fusion variable? Thank you! -Ryan

[kyle969]

Try this:
<cfquery name='runSqlStatement'>
#preserveSingleQuotes(retrieveSqlStatementToRun.sq lData)#
</cfquery>

inside a cfquery block CF replaces ' with ', using this function prevents that.

[ryanstewart]

Works like a charm, thanks!