i think doing the pagination in the sql is the better way.
you can do it using nested selects.
the sql for getting the rows between 50 and 100 goes like this :
select FIELDNAME, USERID from
( select FIELDNAME, USERID, rownum num
from ( select A.FIELDNAME, B.USERID
from wdchangelog A, WSUSERS B
where A.configUnitID = ?
and A.USERUID = B.userUID
order by A.FIELDNAME ) a
) b where num between 50 and 100
the above is specific to oracle. but all DBs have equivalent of this.
regards
ashok
On Dec 10, 2007 1:55 PM, Stefano Tranquillini <
[EMAIL PROTECTED]> wrote:
> Hi,
> someone know's how i can have a paginedQuery?
> i try to use queryForPaginatedList but is deprecated.
> tnx
>
> --
> Stefano
