>I think she means she wants to be SURE she doesn't display those >records again - and if a new record is added between first page and >next page, then starting with the 6th record is no longer accurate.
Why not create a list as a session variable, and on each time you visit the page dump the id's into that. Then in your next page have something like this: <cfparam name="session.alreadyDisplayed" default = "" /> <cfquery etc> select top 5 foo from bar <cfif structKeyExists(session,"alreadyDisplayed") and len(trim(session.alreadyDisplayed))> where foo not in #session.alreadyDisplayed# </cfif> </cfquery> <cfset variables.addToList = valueList(foo)/> <cflock etc> <cfset session.alreadyDisplayed = session.alreadyDisplayed & variables.addToList /> </cflock> hth, larry ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:292025 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
