Re^3: DBI Hash of Column name values

http://search.cpan.org/dist/DBI/DBI.pm#selectall_arrayref

use Data::Dumper;
print Dumper( [ [ { 1, 2 }, [ [ { 6, 7 } ] ] ] ] );
__END__
$VAR1 = [
          [
            {
              '1' => 2
            },
            [
              [
                {
                  '6' => 7
                }
              ]
            ]
          ]
        ];
[download]

Comment on Re^3: DBI Hash of Column name values Download Code

Replies are listed 'Best First'.
Re^4: DBI Hash of Column name values by avrono (Novice) on Aug 09, 2010 at 20:30 UTC
Thanks for all the wisdom ! I am not sure how efficient my final solution is, but I wanted an array of hashes. This works `my %rec; $sth->bind_columns (\(@rec{@{$sth->{NAME_lc}}})); while ($sth->fetch) { my %res = %rec; push(@result, \%res); } return \@result;` [download]	[reply] [d/l]