Re: Shorthand for $dbh->prepare and $sth->execute?

[Michael A Mayo]

----- Original Message ----- 
From: "Philip Mak" <[EMAIL PROTECTED]>
> > > $rows = $dbh->selectall_hashref("SELECT ...");
> > > for my $row (@{$rows}) {
> > >   do something with $row
> > > }

> What's the efficient way of doing this? $sth->fetchrow_hashref?

A traditional for loop.

for ( my $i = 0; $i <= $#$rows; $i++ ) {
   do something with %$row->[$i]
}

          -Mike