RE: Resetting of the dataset

From: Brian Barto (brian.barto_at_spectrum-health.org)
Date: 12/16/04


To: beginners@perl.org
Date: Thu, 16 Dec 2004 15:42:21 -0500

I just realized I was way off base from your original question. :) You want
to start over again from the beginning with fetchrow_array(). I think it's
just a matter of running the execute statement again to reset it...

-----Original Message-----
From: Nicolay Vasiliev [mailto:nvasiliev@whiteriversoft.com]
Sent: Thursday, December 16, 2004 10:14 AM
To: beginners@perl.org
Subject: Resetting of the dataset

Hello there!

I have some dataset got by the executing of some query. For example:

my $sth = $dbh->prepare('select * from sometable');
$sth->execute();

Going through this dataset by $sth->fetchrow_array() I need to go back
inside this proccess. Sorry, but I have no idea how can I do this. How
can I reset this dataset to move to the first record?

TIA.

-- 
To unsubscribe, e-mail: beginners-unsubscribe@perl.org
For additional commands, e-mail: beginners-help@perl.org
<http://learn.perl.org/> <http://learn.perl.org/first-response>
-- 
To unsubscribe, e-mail: beginners-unsubscribe@perl.org
For additional commands, e-mail: beginners-help@perl.org
<http://learn.perl.org/> <http://learn.perl.org/first-response>


Relevant Pages

  • Re: cups works but dont print out!
    ... plug to another machine it reset itself. ... ErrorPolicy retry-job ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: crazy screen
    ... Is there a way to reset the settings? ... is to find any CRT or LCD that can fit to your ... Then you can try to reset things. ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: cups works but dont print out!
    ... different from config printer, or when I print but paper tray is empty ... plug to another machine it reset itself. ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • Re: user permissions problems
    ... if it is set, reset it ... reinstalled gedit, ... >> Modify settings or unsubscribe at: ...
    (Ubuntu)
  • Re: installation problem with AMD CPU and Board
    ... > then system try to boot again after reset but it's delayed on this ... To unsubscribe, ...
    (freebsd-questions)