Re: how to handle Pagination >

At 12:54pm -0400 Tue, 15 Oct 2013, Vik Fearing wrote:
> On 10/15/2013 05:01 PM, jesusthefrog wrote:
>> You will probably want to use OFFSET and LIMIT, which are the
>> window size and page. Something like
>>
>> SELECT .. FROM ... WHERE ... ORDER BY (...) OFFSET y LIMIT x
>>
>> So say you want to get 100 records at a time. You would get page 1
>> with OFFSET 0 LIMIT 100, then page 2 with OFFSET 100, OFFSET 200,
>> and so on.
>
> You will most certainly NOT want to use that technique.
>
> Instead, try these links:

Doh!  My previous email was late!  Vik wins this round!  :-)

Kevin