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 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278266 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
