I think that will just dump the results of the query, I think he wants to see the actual SQL.
Just enable debugging and the query will show up in debugging info. Russ > -----Original Message----- > From: Bryan F Hogan [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 08, 2006 10:34 AM > To: CF-Talk > Subject: RE: see my query - watch it fail > > <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:259639 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
