Why not write the query text into a session variable when you
execute it the first time?
Nick
-----Original Message-----
From: Chris Phillips [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 10:51 AM
To: CF-Talk
Subject: any way to retrieve the actual SQL used
Hi all
Is there any way to retrieve the actual SQL (rather than the records
returned) by a dynamic query?
ie I have a page that bases its query on the form fields filled in on the
previous page. I want to actually use the SQL statement for sth else.
It comes out if you turn debugging on, but is it accessible eg as a variable
of some sort?
Any thoughts are welcome
Many thanks in advance
Chris
====================================
chris phillips
communisis one plc multimedia team
0113 225 5373
mailto:[EMAIL PROTECTED]
http://www.communisis-one.co.uk
====================================
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
