Dears, I paginate records using a medium complex query with :conditions : like id in (select ....) and id in (select ..) Because that query is very high cost in time and ressources I'aint to add additionnals queries for counting or else. Once one record is displayed, how access the next id in the paginated collection, w/o querying again just for next id ? Like : id name 45 bob 47 bill 98 rob 78 david In displaying rob's record (/show/98) i'll like to have Next and Previous record. Thanks ,
on 2005-12-08 16:21
on 2005-12-08 17:39
In your paginate query pull down 1 more record than you display just so you know its "Next" ID.