Tnx so i've to made the pagineted query by myself. and, if i extract all the results and show only the result beteween an interval is the samething? PS: why paginated list has been deprecated? regards
On Dec 10, 2007 3:51 PM, Ashok Madhavan <[EMAIL PROTECTED]> wrote: > 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 > > > -- Stefano
