Re: Stupid newbie question?

Ben wrote:
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?




So long as you are not bothered about the result-set changing between
the first and second pass do:

$rs = $dbh->selectall_arrayref($sql, undef, $p1, $p2 ...)

or (selectall_hashref).

then:

while (my $row = @{$rs}) {
print $row->[0]; # first column, n'th row
}

Make sure RaiseError is on or check for $dbh->err;

If you are bothered about a change run selectall_arrayref twice.
However, I'd question why you need to process the result-set
twice IF you are not bothered about it changing. If the result-set
can change then you are talking cursors that pick up changes
and that is very db specific.

Martin
.

Relevant Pages

  • reset header format
    ... entering. ... no longer automatically types over it. ... I've deleted 1033 twice to reset the building block file and I've had Word ...
    (microsoft.public.word.docmanagement)
  • Re: WDF supplied functions send reset packet twice through USB
    ... If a reset is being sent twice, it has nothing to do with KMDF. ... I am using wdf to make a usb dfu driver. ... How to reset device just single ...
    (microsoft.public.development.device.drivers)
  • Re: Radio Code entered but stereo wont play
    ... I thought it took twice as long before you could have another go each time - ... you must reset it by leaving the radio powered on, ... It doesn't take any of the entries I ...
    (alt.autos.bmw)
  • Re: Blue screen
    ... So I have to reset it once often twice ... before I can get XP SP2 to load. ...
    (microsoft.public.windowsxp.setup_deployment)