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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Protect your mail server with built in anti-virus protection. It's not only good for you, it's good for everybody. http://www.houseoffusion.com/banners/view.cfm?bannerid=39 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1272 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
