RE: [Reactor for CF] query page record navigation

[Doug Hughes]

As a note, using iterators with pagination is pretty simple.  If you load the iterator up into a session var then you can call something like getQuery(1,10) or getQuery(11,10) to return the first or second sets of 10 items in the query.  The nice thing is that you can do this with Records too.  IE: getArray(11,10) will return the second page of 10 records.  As a note, if you use getArray only the records you request are instantiated.  In other words it’s pretty handy for paging over larger datasets.   Doug   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Sims Sent: Thursday, July 20, 2006 9:01 AM To: reactor@reactorframework.com Subject: Re: [Reactor for CF] query page record navigation   Gareth, I would love to see how you did the pagedquery.cfc. Have you considered releasing it as a resource to the community? Doug S. www.evenamonkey.com On 7/20/06, Gareth Cole <[EMAIL PROTECTED]> wrote: Hi Dan,   I built a PagedQuery.cfc a while back to handle paging. You just initialize it with a query and the number of records you want per page. It then has a whole load of methods for navigating around.   Let me know if you want a copy. I'm still fairly new to OOP with CF, so would welcome constructive comments   Gareth   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dan Vega Sent: 19 July 2006 21:42 To: reactor@reactorframework.com Subject: Re: [Reactor for CF] query page record navigation   Yes so a getAll() returns 100 records but we want to have x pages with x number of records per page. On 7/19/06, João Fernandes < [EMAIL PROTECTED]> wrote: What do you mean by a regular record? navigate between records from any query? João Fernandes -----Original Message----- From: [EMAIL PROTECTED] on behalf of Dan Vega Sent: Wed 19-Jul-06 9:24 PM To: reactor@reactorframework.com Subject: [Reactor for CF] query page record navigation I see that with an Iterator you can set the total amount of records returned along with the starting record. This would be great for page navigation of records. Is there anyway to do this with a regular record? I am trying to figure out the easiest way to provide this feature for my application without writing a custom funciton. <cfset customers = AddressRecord.getCustomerIterator ().getQuery(10, 5) /> -- Dan Vega [EMAIL PROTECTED] -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Dan Vega [EMAIL PROTECTED] -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List reactor@doughughes.net Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --