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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278255 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
