So a small change - but a nice one. If you dump a query in ColdFusion 8, you now get a set of additional information along with the data. You get...

  • Whether or not the query was cached
  • The execution time
  • And best of all - the SQL!
  • Lastly - if your SQL contained any cfqueryparam tags, there will be a SQLParameters key that is an array of the values used in the cfqueryparam tags.

Edited to add last bullet point.

Download attached file.