Sorry I don't understand the point in your reply? I already pointed out that this other method does exactly the same thing, but also adding an additional query. We know what my original example does, as that was the whole point in this topic.
Russ -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: 31 August 2005 15:00 To: CF-Talk Subject: Re: Paging through records >>Your method would produce the same results, but with 1 more unneccisary trip to the database. What counts is not the "number of trips" to the database, but what you're asking the database to do at every trip. >><cfoutput query="whatever" startfrom="#startfrom#" maxrows="#maxrows#"> This will make CF use only a small part of the query. But the query will still have to get all records. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217003 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
