If you are letting a user browse through pages of result, it might be useful to store the result set in session so you don't have to re-run it every time they switch pages. This would be most useful if it is a long query which taxes your database. As long as the search criteria haven't changed, there is really no need to hit the database again.
~Brad -----Original Message----- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 08, 2006 9: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? -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:259637 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
