Try caching the query. That will keep it from hitting the database again. Clint
----- Original Message ----- From: "admin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 19, 2003 12:35 PM Subject: Large Recordset Display Problem > I have a query that returns the results of a search. Potentially this could be a few hundred records. What I want to be able to do is execute the query once (as it's a slow query) but then only display a limited number of records per page (25 or so) and have some navigation to move thru the results, but with out re-doing the search. > > Any thoughts ? > > TIA > > Richard > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4