> I'd like to output the completed SQL Query that I'm
writing to CFQuery to the
> screen so I can see what the report is querying the
> I tried <cfoutput>#myquery#</cfoutput> but
that didn't work.
in cf7 you can get several bits of of metadata about a
result_name.sql: The SQL statement that was executed.
result_name.recordcount: Current row of query that cfoutput
result_name.cached: True if the query was cached; False
result_name.sqlparameters: An ordered Array of cfqueryparam
result_name.columnList: Comma-delimited list of the query
result_name.ExecutionTime: Cumulative time required to
process the query.