You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Javier Urbaneja <ur...@gmail.com> on 2006/09/18 11:49:15 UTC
groupBy with queryForList with skip and max
It seems (for the results i'm getting now) that in
"
*queryForList*(java.lang.String id,
java.lang.Object parameterObject,
int skip,
int max)
Executes a mapped SQL SELECT statement that returns data to populate a
number of result objects within a certain range.
"
skip is referring to the rows skipped in the resultset and not to skipped
result objects.
I've seen it stated here:
http://www.mail-archive.com/user-java@ibatis.apache.org/msg00829.html
but it's a year old post.
Can anybody confirm this?
If it's true, maybe the warning note in page 38 of the devoloper guide,
about combining groupBy and PaginatedList, could mention this as well, as is
generating confusing results.
If all that is correct i can make the modification if it is needed.
Thank you for your attention.
Re: groupBy with queryForList with skip and max
Posted by Javier Urbaneja <ur...@gmail.com>.
Thank you very much, Larry.
On 9/18/06, Larry Meadors <lm...@apache.org> wrote:
>
> Yes, it is skipped rows.
>
> Larry
>
>
> On 9/18/06, Javier Urbaneja <ur...@gmail.com> wrote:
> > It seems (for the results i'm getting now) that in
> > "
> > queryForList(java.lang.String id,
> > java.lang.Object parameterObject,
> > int skip,
> >
> > int max)
> > Executes a mapped SQL SELECT statement that returns data to populate a
> > number of result objects within a certain range.
> > "
> >
> > skip is referring to the rows skipped in the resultset and not to
> skipped
> > result objects.
> >
> > I've seen it stated here:
> > http://www.mail-archive.com/user-java@ibatis.apache.org/msg00829.html
> > but it's a year old post.
> >
> > Can anybody confirm this?
> > If it's true, maybe the warning note in page 38 of the devoloper guide,
> > about combining groupBy and PaginatedList, could mention this as well,
> as is
> > generating confusing results.
> >
> > If all that is correct i can make the modification if it is needed.
> >
> > Thank you for your attention.
> >
>
Re: groupBy with queryForList with skip and max
Posted by Larry Meadors <lm...@apache.org>.
Yes, it is skipped rows.
Larry
On 9/18/06, Javier Urbaneja <ur...@gmail.com> wrote:
> It seems (for the results i'm getting now) that in
> "
> queryForList(java.lang.String id,
> java.lang.Object parameterObject,
> int skip,
>
> int max)
> Executes a mapped SQL SELECT statement that returns data to populate a
> number of result objects within a certain range.
> "
>
> skip is referring to the rows skipped in the resultset and not to skipped
> result objects.
>
> I've seen it stated here:
> http://www.mail-archive.com/user-java@ibatis.apache.org/msg00829.html
> but it's a year old post.
>
> Can anybody confirm this?
> If it's true, maybe the warning note in page 38 of the devoloper guide,
> about combining groupBy and PaginatedList, could mention this as well, as is
> generating confusing results.
>
> If all that is correct i can make the modification if it is needed.
>
> Thank you for your attention.
>