Just FYI, that only works in CF7. -----Original Message----- From: Peterson, Chris [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 16, 2007 7: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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278259 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
