in reply to 3Re: Perl Beginners problem with DBI
in thread Perl Beginners problem with DBI

In the spirit of TMTOWDI, one can also write 
my $query = q(select * from foo);
my $sth = $dbh->prepare_cached($query);
print Dumper $sth->fetchall_arrayref({});

[download]

The benefit here is that the parsed form of the query has been cached for future use.

------
We are the carpenters and bricklayers of the Information Age.

Please remember that I'm crufty and crochety. All opinions are purely mine and all code is untested, unless otherwise specified.

In Section Seekers of Perl Wisdom