ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sundar Sankar <fatboys...@gmail.com>
Subject Re: Pagination by objects
Date Mon, 27 Jul 2009 18:37:46 GMT
or you could select * from (select rownum as ro, * from XXXView) where ro
between 1 and 1000.

If you had rownum as part of your view, I guess you could use that as the ID
and Ibatis queryForList might work too.

On Mon, Jul 27, 2009 at 11:30 AM, Clinton Begin <clinton.begin@gmail.com>wrote:

> Larry,
> He's doing a join, so each result object is made up of possibly many rows.
>  So simply skipping arbitrary rows will create incomplete objects.
>
> Clinton
>
>
> On Mon, Jul 27, 2009 at 12:12 PM, Larry Meadors <larry.meadors@gmail.com>wrote:
>
>> I'll put this as nicely as I can: What the heck are you talking about?
>>
>> Larry
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>
>>
>


-- 
Regards
Sundar S.

Mime
View raw message