Re: how to fetch all records

2005-02-25 Thread Jeffrey . Seger
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

Re: how to fetch all records

2005-02-25 Thread Tom Mornini
-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

RE: how to fetch all records

2005-02-25 Thread Rutherdale, Will
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

RE: how to fetch all records

2005-02-25 Thread Rutherdale, Will
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