>>You could start with the documentation...or even just your IDE code
>>completion... :-)
>>Look up the queryForList method signatures..
queryForList is taking start row number and end row number.
For example if I have temp table with 200k rows which was build using left
joins, and if I will ask return from 0, 1000 it will return 6 Objects the
6th object will not be complete because the rest of the data is in rows from
1001-1300
Example of the table
ROW ID A B C D E F
1 1 null null 0 0 0 0
2 1 null null 0 0 0 1
3 1 null null 0 0 1 0
4 1 null null 0 0 1 1
5 1 null null 0 1 0 0
6 1 null null 0 1 0 1
7 1 null null 0 1 1 0
8 1 null null 1 1 0 0
9 2 null null 0 0 0 0
10 2 null null 0 0 0 1
11 2 null null 0 0 1 0
12 2 null null 0 0 1 1
13 2 null null 0 1 0 0
14 2 null null 0 1 0 1
15 2 null null 0 1 1 0
16 2 null null 1 1 0 0
If I will ask to get from
queryForList("get", 0,10)
I will get 2 Objects but second object will not be complete
Clinton Begin wrote:
>
> You could start with the documentation...or even just your IDE code
> completion... :-)
>
> Look up the queryForList method signatures..
>
> Clinton
>
> On Fri, Jul 24, 2009 at 4:39 PM, John Seer <[email protected]> wrote:
>
>>
>> Hello,
>>
>> I am using in one of my projects ibatis and have a problem with
>> pagination.
>>
>> For example I want to select 100 objects at a time and skip first 100 of
>> them. I didn't find any good way of doing it and nothing exciting about
>> scrolling too.
>>
>>
>> Any suggestion how to achieve/solve my problem?
>>
>>
>> Thanks
>> John
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Pagination-by-objects-tp24652955p24652955.html
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
>
>
The
--
View this message in context:
http://www.nabble.com/Pagination-by-objects-tp24652955p24685472.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
