Sorry, I was referring to the structure that's returned in the variable specified by the result attribute, but I wasn't nearly as clear as I should have been.
On 5/24/06, Rick Root <[EMAIL PROTECTED]> wrote: > 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:241357 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54