List:General Discussion« Previous MessageNext Message »
From:Ed Carp Date:February 15 2000 3:09pm
Subject:Re: Previous and Next records
View as plain text  
sinisa@stripped (sinisa@stripped) writes:

> Joseph R. Junkin writes:
>  > Is there any way to grab the 'Previous' or 'Next' record from a
>  > previously select record without having to iterate through the whole
>  > set? I am using DBI and I need this to work with dynamic (sorted or
>  > grouped) sets.
>  > Any ideas?
>  > 
>  > Thanks,
>  > Joe Junkin
>  > jjunkin@stripped
>  > 
> 
> Hi!
> 
> Cursors are on a TODO list with a high priority !

He could also use MyC, which supports MoveNext and Move Previous, if he were
writing in C.  MyC fetches the entire result set, so you can do stuff like this.
Doesn't the Perl DBI module let you do something similar?
Thread
Previous and Next recordsJoseph R. Junkin15 Feb
  • Re: Previous and Next recordsDave VanHorn15 Feb
  • Re: Previous and Next recordssinisa15 Feb
Re: Previous and Next recordsEd Carp15 Feb