Daniel, If you put the "result" attribute in the query tag:
<cfquery name="" result="QueryResult">...</cfquery> And then dump out the result: <cfdump var="#QueryResult#" /> This will have the SQL that was passed in as well as all CFQueryParam values. Also, a minor point, the output will look like crap (one giant wrapped line of text). However, if you view the source of the CFDump (view page source), the SQL is formatted just as it was in the CFQUery tag. Much easier to read. ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 08, 2006 10:31 AM To: CF-Talk Subject: see my query - watch it fail 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:259634 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
