in reply to DBI: Build array of hashes with fetched results?

my $res = $sth->fetchall_arrayref({});

will give you a ref to an array of hashes.

Update: Which you can readily use to populate a <TMPL_LOOP> in samtregar's most excellent HTML::Template. Just make sure to have <TMPL_VAR>'s for all the columns queried, else H::T will croak if used with die_on_bad_params => 1 (a good default setting anyway).

--

when small people start casting long shadows, it is time to go to bed

In Section Seekers of Perl Wisdom