You could also put it between CFSAVECONTENT tags if you want to save it to a variable.
> -----Original Message----- > From: charlie griefer [mailto:[EMAIL PROTECTED]] > Sent: Friday, February 14, 2003 11:14 AM > To: CF-Talk > Subject: Re: Get Actual Query Run > > > Is it just that you want to see the actual SQL code that was > passed to the > database? > > Just take the code between your <cfquery></cfquery> tags and > pop it into > <cfoutput></cfoutput> tags. > > ? > > charlie > > > Michael Ross writes: > > > I have a question. I have a query that is built depending > on many things, the where statement, order by, actual columns > asked for that kinda thing..... I want to save what the > actual sql text is that ran that query. Like what you can > see in the debugging code. Does this make sense? Any help > would be great. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4