Hi!
Yes, you are near of the truth :). But if I use some complicated joining query to few large tables I think this is not too comfortable for the server.
Brian Barto wrote:
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:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 10:14 AM To: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>