Re: Dumping query info after running query
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:241354 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
Re: Dumping query info after running query
Ray Camden blogged about this just yesterday. http://ray.camdenfamily.com/index.cfm/2006/5/23/Ask-a-Jedi-Saving-a-Dump-for-Later Joelle Rick Root 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:241355 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
Re: Dumping query info after running query
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 addresult="foo" to the 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
Re: Dumping query info after running query
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 addresult="foo" to the 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
RE: Dumping query info after running query
> Ray Camden blogged about this just yesterday. > http://.../Ask-a-Jedi-Saving-a-Dump-for-Later I like Ray and all, but you couldn't pay me to click on that link. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241374 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
Re: Dumping query info after running query
Dave Watts wrote: >>Ray Camden blogged about this just yesterday. >>http://.../Ask-a-Jedi-Saving-a-Dump-for-Later > > > I like Ray and all, but you couldn't pay me to click on that link. Hah. Looks like questionable content to me! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241438 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