traversing results of DBI recordset

[Rovent]

Hullo All -

does anyone know of a function in DBI that can be used to traverse the records returned from a query? here's my problem.

I run my query, and it returns, say, 5 records.

all the examples and searching i've done only allow for forward traversals (fetch, fetchrow, fetcharray) using while loops to plow through the entire table.

I need to be able to print a record, and then go to the previous record, or at the very least, go back to the beginning of the recordset without having to re-execute the query. In a perfect world, it'd kind of replicate the C 'seek' function, like $db->seek(3) to go to the third record. . .

 

[raztaboule]

from :

http://dc.pm.org/talks/perl_db.html

fetchall_arrayref
Gets all the rows from the database for you, returning an arrayref with each member as an arrayref of values from the database.