well, before it's performed you can just pop the SQL inside of <cfoutput> tags. if you're on MX7, there's a new attribute for the <cfquery> tag called "SQL" which is returned as part of the new "result" attribute (which returns a structure).
<cfquery name="myQuery" ... result="myResult"> .... </cfquery> <cfoutput>#myQuery.myResult.SQL#</cfoutupt> On 11/8/06, Daniel Kessler <[EMAIL PROTECTED]> wrote: > I have a really cool query for a SEARCH form. It has an AND/OR radio > button between fields. It is a paged query and when I click on page > 2, it gives me fewer hits than when I was on page one. Very wrong. > > I'd like to see the query as it's being performed or before it's > performed, whichever, to diagnose the problem. Is there a way to > output the query to see what it's asking? > > -- > > Daniel Kessler > > College of Health and Human Performance > University of Maryland > Suite 2387 Valley Drive > College Park, MD 20742-2611 > Phone: 301-405-2545 > http://hhp.umd.edu > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259636 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
