Re: fetching rows from a certain point after closing cursor

I am not sure if i understand correctly; your :last_retriever_primary key - is it stored in the same table? If this is true, it's value will be changing concurrently for different users accessing your site in parallel, right? The whole point was to make this thing work per user. Or am i missing something?

Regards

Vlad

On Tue, 10 Sep 1996, Carlos Augusto Leite Netto wrote:

> Vladimir Stavitsky wrote:
> >
> > I am afraid you have no choice other than put the number of records
> > already read into either hidden field in html form or in a DB record
> > which is unique for this user. When he comes again - just fetch
> > the records after the last one he read already.
> >
> > Hope this helps
>
> That's a good idea for general situations. If you're creating a general
> template, it's Ok. But if you're writing a program by hand and your table
> as a primary key based on a unique column, you can:
>
> select *
> from table
> where primary_key > :last_retrieved_pk and
> order by primary_key
>
> fetch how many rows you want (if you're creating a table browsing for
> HTML, for example) and register in :last_retrieved_pk the pk of the
> last rows fetched.
>
> It's not so generic, but's faster. If you primary_key is based on two
> or more fields, it's not so easy to take advantage of the pk's index
> to speed up the solution.
>
> Regards,
> --
> Name: Carlos Netto e-mail: cnetto_at_softdes.com.br
> Software Design Informatica Oracle System Integrator
> Oracle BAP member. Softex/2000 member. Campinas, Sao Paulo, Brazil
>
>
>
>

        ... occurrences like this will be few and far between ...

http://www.webvalue.com Vlad Stavitsky vlads_at_lvalue.com