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