Stupid newbie question?

Hey guys, I'm very green at DBI stuff, so maybe this is a stupid question. But after going through the DBI man page and searching the web for a couple hours, I can't find the answer. All I'm looking to do is to walk the result set from a select statement more than once. Every example I can find follows the form:

prepare, execute, fetch, fetch, fetch, ..., finish

What I would *like* to be able to do is walk the entire result set, and then, once I get to the end, reset the statement handle to point the fetch calls back to the top, and then walk them again. That seems so simple. Is there really no "reset" command? Do I actually have to execute the select again?
.

Relevant Pages

  • Re: mysql DB specific primary key
    ... those gaps is at best not recommended and at worst a mild case of OCD. ... He didn't suggest you reset it. ... Odd people are going to think odd things, ... I was thinking more like the DBI select command with the ...
    (comp.lang.perl.misc)
  • Re: Q: Problem figuring out versions of DBI
    ... I have a bunch of DBI questions I'm hoping ya'll can help me ... but I'm stymied after searching ... >The reason why I'm trying to figure out my DBI version is so that I ...
    (comp.lang.perl.misc)
  • SQL Server Precision
    ... I am a perl and DBI novice, so pease forgive the possible stupid question. ... problem is the rounding between a select statement in the query analyzer and ... perl's/DBI's display format/precision to match SQL Query Analyzer? ...
    (perl.dbi.users)
  • MySQL through DBI to XML - module advice wanted
    ... I am looking for the most appropriate module to do some basic MySQL ... through DBI to XML translation. ... A bit of searching has found DBIx::XML_RDB which looks like just the ...
    (comp.lang.perl.misc)