Re: Database cursors

Oliver Vidovic wrote:
> [ a question nobody understood ;-) ]

 Let me try explaining the problem again. I'm somewhat new to ObjectStore, and I have to learn what exactly our system looks like and how the database is done.
 I've clumsily used 'page' thinking of web page, and not of ObjectStore's page. This probably confused you.

 User performs a search on data contained in the database, and there are hundreds, maybe thousands of results. In order not to swamp user with results, I'd like to show the user a subset of it (first 20 results, for example), and then provide the user with previous/next links, which would lead him to the previous/next subset of data. Also ideally, user could see some message like: "1 - 20 out of 1534".  I am not going to try to explain how our system currently works, and there are several reasons for this. First, I'm not sure how it works, and I don't want to waste anyone's time explaining and re-explaining. Second, I'd like to try to find the information on how this functionality can be implemented, because we might change the way we currently implement our system based on this new information.

 One of the things I was just wondering is, if there's a way to somehow determine correctly, or even approximately the number of results that are returned from search. I've seen both Google and Deja (if the search returns large set of results), give approximate number at the first subset of results (for my example, it would probably be 1500, or maybe even 2000), and then as you go to the next subset of results, the approximate number narrows down to exact number.

 If you can point me to any resources on web/books regarding these issues, it would be very helpful.
 Thanks for reading/replying to my question.

-- 

Thanks.
oliver

(reply: read email address for instructions)