ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stefano Tranquillini" <stefano.tranquill...@gmail.com>
Subject Re: Deprecated paginatedList
Date Mon, 10 Dec 2007 16:14:27 GMT
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 <ashok.madhavan@gmail.com> 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 <stefano.tranquillini@gmail.com>
> wrote:
>
> > Hi,
> > someone know's how i can have a paginedQuery?
> > i try to use queryForPaginatedList but is deprecated.
> > tnx
> >
> > --
> > Stefano
>
>
>


-- 
Stefano

Mime
View raw message