What Is This?

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:

queryName (Datasource=dopefly, Time=1176ms, Records=10) in C:\.....

      select top 10 *
      from blogComments
      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="queryName" datasource="dopefly">
    select top 10 *
    from blogComments
    where Name = 'MrNate'
    or Name = 'Nathan Strutz'
    and subscribe = 0
</cfquery>