The CFQuery Reassembler takes queries from your ColdFusion server debugging information and reassembles them into usable queries.
It will take a query from this type of debugging output:
qryName (Datasource=dopefly, Time=100ms, Records=10)...
select * from comments where Name = ? or Name = ? and subscribe = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = MrNate
Parameter #2(cf_sql_varchar) = Nathan Strutz
Parameter #3(cf_sql_integer) = 0
and turn it back into this:
<cfquery name="qryName" datasource="dopefly"> select * from comments where Name = 'MrNate' or Name = 'Nathan Strutz' and subscribe = 0 </cfquery>