miconductor
[EMAIL PROTECTED]
Tom Mornini <[EMAIL PROTECTED]>
02/25/2005 12:28 PM
To: Perl - DBI users
cc:
Subject: Re: how to fetch all records
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Feb 25, 2005, at 9:22 AM
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Feb 25, 2005, at 9:22 AM, Tiffany Thang wrote:
Is there another way of fetching all table records in one statement
without going through a loop?
What I have now is as follows:
while (@eachrec=$sth->fetchrow_array) {
do whatever;
}
I want to r
Whoops. I mean selectall_arrayref() (for the general case).
-Will
-Original Message-
From: Rutherdale, Will
Sent: Friday 25 February 2005 12:26
To: dbi-users@perl.org
Subject: RE: how to fetch all records
The simplest is $dbh->selectrow_arrayref().
It's documented in the
The simplest is $dbh->selectrow_arrayref().
It's documented in the DBI man page.
-Will
-Original Message-
From: Tiffany Thang [mailto:[EMAIL PROTECTED]
Sent: Friday 25 February 2005 12:23
To: dbi-users@perl.org
Subject: how to fetch all records
Is there another way of fetching all ta