Fabian <fabianpi...@gmail.com> wrote: > 2011/10/12 Igor Tandetnik <itandet...@mvps.org> > >> >> See if this helps: http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor > > > I tried to implement the method as suggested in the article, but it will > only work for pagination where the user is only allowed to go 1 page back or > 1 page forward (since you have to remember the last rowid). In my case, the > user is allowed to jump to the last page, without visiting any of the > previous pages, making the suggested method impossible to implement.
To get to the last page, you could reverse the ORDER BY, effectively reading backwards. Of course you'll have to reverse again in the application code, for presentation. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users