Dude! That's cool. Now I *really* wish I was running on CF7. :o) Rick, I probably should have stated that my way is what I do in CFMX6.1
Chris Andy Matthews wrote: > 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:267188 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4