The data is still available on CF6.x, you just have to go digging. Check the debug output templates, they have all kinds of goodies (including this one).
cheers, barneyb On 5/16/07, Christopher Jordan <[EMAIL PROTECTED]> wrote: > Man, I hate being stuck on MX6.1. That little gem could have saved me > loads of work! *grumble*... Well, I'm keeping my fingers crossed that I > can get my client to upgrade to CF8 or maybe get that cool CF7 > discount/upgrade deal that Ben Forta blogged about a day or two ago. > > > Huff, Jerome P. wrote: > > Thanks, That worked like a charm! > > > > Jerome > > > > -----Original Message----- > > From: Peterson, Chris [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, May 16, 2007 8:21 AM > > To: CF-Talk > > Subject: RE: Get the SQL Query > > > > Set the result attribute of your query, ie: > > > > <cfquery name="getData" result="getDataResult"> > > > > > > Then just dump the #getDataResult# That will give you all kinds of > > goodies =) > > > > Chris > > > > -----Original Message----- > > From: Jerome Huff [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, May 16, 2007 8:08 AM > > To: CF-Talk > > Subject: Get the SQL Query > > > > How can I get at the actual query that is sent to the database. I can > > see it on the debug page, but how would I get it in a variable so I > > could stick it in the database or display it? Thanks > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278268 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
