if you're using CFMX than you can get at this data by interrogating the Service Factory. This is undocumented, but fun to discover!
If you're not using CFMX then you can't access the debugging information, unfortunately. > -----Original Message----- > From: bajaria aslam [mailto:aslambajaria@;yahoo.com] > Sent: 30 October 2002 14:01 > To: CF-Talk > Subject: capturing a query > > > Hi List. > > When you have the debugging on, you can see that it > shows the sql generated also. You may have > #variableName# in the <cfquery> template, but finally > when all the variables get resolved, you have a query > that is sent to the database. > > That query can be seen when the debugging is on on the > webpage. > > is there a way to capture that final query? > > i tried #cgi.QueryName# , but did not work. > > Any ideas? > > thanks list > > __________________________________________________ > Do you Yahoo!? > HotJobs - Search new jobs daily now > http://hotjobs.yahoo.com/ > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk 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
