Re: fetching rows from a certain point after closing cursor

Ashley Coutinho wrote:
> User conducts a query.
> Declare cursor
> User asks for the next 20.
> ?????? How do I start from the previous point
> without querying the old 20 records ????????

Here's how I did it.

First, you must have a means of identifying your place in the query, either a primary key, or like it.

when the user fetches, you send back a hidden field containing the key value of the last value looked up. when they execute the next fetch, you simply start from where you left off. Pretty neat, eh? These are the rudiments of the cookie system. Doing it by hand
sure makes things easy.

bcmartin Received on Mon Sep 09 1996 - 00:00:00 CEST