Re: Pagination (should be basic)
Russ > I'm trying to understand how to do simple pagination This is called a next-n interface. There are quite a few web resources on this if you do a search. Basically you need to do a CFQUERY... CACHEDWITHIN... to get the data efficiently, then display it on the page using variables to keep track of what the numbers of the first and last rows to display for the current page in the query are, using CFLOOP QUERY=... STARTROW=... ENDROW... Nick __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Pagination (should be basic)
All, I'm trying to understand how to do simple pagination--that is, return a list of results or enter a page and only present the first X results. Likewise, I'd like to be able to present the next set of results (from x*2 to x*3), etc. Thank you for any assistance/pointers. Russ __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
