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 retrieve all the records into an array first and process it
later on. What would
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
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 DBI man page
-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
]
Tom Mornini [EMAIL PROTECTED]
02/25/2005 12:28 PM
To: Perl - DBI users dbi-users@perl.org
cc:
Subject:Re: how to fetch all records
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Feb 25, 2005, at 9:22 AM, Tiffany Thang