David Hind-Smith wrote: >Hello all, > >I'd like to do a CFDUMP of an SQL expression that was created by a >query...Not the actual records, but the SQL expression that was created. > >My CFQUERY Name="Tiersearch" > > >....this dumps the records ><CFDUMP VAR="#TierSearch#"> > >....How do I dump the SQL expression? > > > 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. 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. Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1270 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
