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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4