Gossamer Forum: General: Perl Programming: Re: [Wil] $sth->fetchall

Gossamer Threads

Home : General : Perl Programming :

General: Perl Programming: Re: [Wil] $sth->fetchall_array: Edit Log

Here is the list of edits for this post

Sep 28, 2001, 1:48 PM

Paul

Veteran (19537 posts)

Sep 28, 2001, 1:48 PM

Re: [Wil] $sth->fetchall_array

I'm not sure if it's the fastest way but it works. I ended up using:

Code:
my $data = $sth->fetchall_arrayref({}); 
                           $sth->finish(); 

              foreach (@$data) { 
                          $res{$_->{Email}} = $_->{Email}; 
              } 

              $DBH->disconnect(); 

              return %res;

Last edited by:

RedRum: Sep 28, 2001, 1:48 PM

Edit Log:

Post edited by Paul Post edited by Paul (Veteran) on Sep 28, 2001, 1:48 PM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676