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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278265 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
