Daniel not sure exactly what you want to see but you could try this: <cfquery name="xxx" datasource="fclounge" result="yyy"> select * from tblbcplayer </cfquery>
<cfdump var="#xxx#" label="Query Results"> <cfdump var="#yyy#" label="Query Attributes"> xxx will dump the results yyy will show you the following attributes: cached?, columnlist, exectiontime, recordcount, SQL executed (not sure when this 'result' attribute became active - cf 6 or 7 ) Not sure if any of that helps you? On 11/8/06, Bryan F Hogan <[EMAIL PROTECTED]> wrote: > <cfdump var="#qry_myQueryName#"> > > -----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:259638 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
