Cause a database error (fat finger the datasource, maybe) and use cfcatch.sql, assuming all you're interested in is the SQL statement.
Matt Osbun Web Developer Health Systems, International -----Original Message----- From: David Hind-Smith [mailto:[EMAIL PROTECTED] Sent: Monday, June 27, 2005 11:03 AM To: CF-Newbie Subject: RE: CFDUMP of SQL expression Hi Stephen, > > Quick answer....you can't.... The easiest way is just to copy the SQL that is generated inside the cfquery and wrap it in a cfoutput, so that it gets output to your page. .....good tip, will file it away. Just seen your other email come in... Doing a CFDUMP of the FORM scope will only output the SQL if the expression has been entered in a form on the previous page or you build the SQL in a form scoped variable. .....which is what I was doing, so luckily in my case it worked. Thanks for the response. -David ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase Homesite Plus with Dreamweaver from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=55 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1273 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
