CF7 has a built in variable that gets returned with every query. It contains the actual final query language. It's [query_name].sql.
http://www.cfquickdocs.com/?getDoc=cfquery -----Original Message----- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Monday, January 22, 2007 1:33 PM To: CF-Talk Subject: How to dump a sql query to text I wish to store the actual text of a SQL query to a logfile. At the risk of belaboring the obvious, from: <cfquery ...> Select * from blah </cfquery> I wish to actual put "select * from blah" into a text variable and write it to a logfile or data table. Can someone suggest an easy way to do this? TNX. Rick Colman ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267183 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
