the info I'm looking for can't be found in the query results. Actually I found it here, thanks to ray camden (this is a different blog entry from the other response to this thread)
http://ray.camdenfamily.com/index.cfm?mode=entry&entry=1CEE22D9-B4B6-62CD-1AC9A7C42D02ACFC Turns out that if you add result="foo" to the <cfquery> tag, it'll store the query metadata in a structure named "foo" - including execution time, column list, the SQL, and any parameters. Thanks Ray! Rick Rob Wilkerson wrote: > You should be able to iterate over the structure to display the key/value > pairs. > > On 5/24/06, Rick Root <[EMAIL PROTECTED]> wrote: > >>How can I dump query debugging data to email? >> >>I want to see the running time, the SQL executed, parameters, etc- >>everything that would normally show up when you turn on debugging. >> >>Rick >> >> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241356 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
