> I have a query that returns anywhere from 1 to 1800 records. I've > implimented a next/previous button but this keeps calling the query over and > over again. Is there a way to return all the records and then process them > using next and previous? I'm thinking something like a structure maybe? Yes... cache the query. You can use the cachedwithin attribute in your cfquery tag. This will cache your query on the server for the time span you set... this would cache the query for 5 minutes: <cfquery name="GetRecords" datasource="#DSN#" cachedwithin="#CreateTimeSpan(0,0,5,0)#"> Setting the time span to 0 will un-cache the query. HTH, Steve ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
