If you only need them ordered by id, it is doable as you can use multiple select statement for the paging.
Otherwise, it is quite cumbersome in SQLObject because it is not lazy enough so there could be a memory concern if you retrieve everything(a list in memory hold in a session). Seperate select doesn't quite work as the rows could have been insert/deleted between page refresh, there may be overlap/missing between page advance. Roman wrote: > Hi > > A piece of code often needed is that which lets you present a large > database result set that spans across several HTML pages (that the user > can navigate). As in Gooooooogle. > > Does TG (or SQLObject) somehow have native support for this? > (or will it in the future?) > > If not, where should I start when using TG, SQLObject and > MySQLPagedResultSet? > > Cheers, > Roman
