Thanks both of you
Chris
^-----Original Message-----
^From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
^Sent: 26 March 2001 10:40
^To: CF-Talk
^Subject: RE: any way to retrieve the actual SQL used
^
^
^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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
