wfsp has asked for the wisdom of the Perl Monks concerning the following question:
In gmax's excellent DBI recipes under the heading 'Getting a list of hashes' he give this example:
my $sth = $dbh->prepare($query2); $sth->execute(); my $employees_loh = $sth->fetchall_arrayref({});
Later, under 'Binding columns and fetching', he explains that:
The fastest method, which you can always count on, is fetchrow_arrayref. It is even faster when you combine it with binding.
Is it useful/possible to bind a list of hashes (as shown above)?.
The following (similar to one of gmax's examples):
update: see note below
for instance, gives:$sth->execute($year, $month); my @array = (); $sth->bind_col(\(@array)); $sth->fetchall_arrayref({});
Any pointers?DBI bind_col: invalid number of arguments: got handle + 0, expected ha +ndle + between 2 and 3 Usage: $h->bind_col($column, \$var [, \%attr]) at etc...
update: gmax's example is for fetchcol_arrayref
Back to
Seekers of Perl Wisdom