Tricky Jumpto record problem...

[Anon]

Hi,
I am trying to write a simple script which performs a select statement on a table and passes the records into a result set. (easy) Here is the tricky part...

I want to then jump to a record within the entries passed into the result set. And then grab a value from the record previous to this and after this in the result set. I cant base this query on the table (it would be easy if i could), it must be based on the results of a query.

Any takers?

Cheers.

[Anon]

If you can find the records in the result set you should be able to find them in the table.

But anyway, how many records are you expecting in the result set? Shouldn't be hard to loop through them, remember the contents of most recent (or previous), if the current row is the one you want output the previous, current, and next row.

Or do you have some other way you are "jumping" to a record, I'm not familiar with that term :⁾

[Anon]

Looping through is a very inefficent way of doing it - especially if the result set is large (which it has potential to be).

Is there a really obvious command i am missing? getting the next record is easy - just move onto the next one.

How do you go backwards one though?