RE: Stupid newbie question?



Isn't this an ODBC thing? Did you look at the DBD::ODBC docs?

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: Ben [mailto:bench@xxxxxxxxxxxxxxx]
Sent: Friday, June 23, 2006 1:48 PM
To: dbi-users@xxxxxxxx
Subject: 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?

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is intended
to be for the use of the individual or entity named above. If you are not the
intended recipient, please be aware that any disclosure, copying, distribution
or use of the contents of this information is prohibited. Please notify the
sender of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

.



Relevant Pages

  • Res: RE: RE: Problems changing from 1.30 to 1.42
    ... With DBI 1.30 it works just it is: ... >>This electronic message transmission is a PRIVATE communication which contains ... >>intended recipient, please be aware that any disclosure, copying, distribution ... >>sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: RE: Problems changing from 1.30 to 1.42
    ... >This electronic message transmission is a PRIVATE communication which contains ... >intended recipient, please be aware that any disclosure, copying, distribution ... >sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: RE: DBI->Connect returning UNDEF in cgi but not in standalone prog
    ... You are returning undef. ... >This electronic message transmission is a PRIVATE communication which contains ... >intended recipient, please be aware that any disclosure, copying, distribution ... >sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: RE: Problems changing from 1.30 to 1.42
    ... >This electronic message transmission is a PRIVATE communication which contains ... >intended recipient, please be aware that any disclosure, copying, distribution ... >sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: make problem
    ... Perl may be copied only under the terms of either the Artistic License or the ... This electronic message transmission is a PRIVATE communication which contains information ... If you are not the intended recipient, please be aware that any disclosure, ... Please notify the sender ...
    (perl.dbi.users)