http://www.perlmonks.org?node_id=516000

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

$sth->execute($year, $month); my @array = (); $sth->bind_col(\(@array)); $sth->fetchall_arrayref({});
for instance, gives:
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...
Any pointers?

update: gmax's example is for fetchcol_arrayref