in reply to DBI and fetchall_arrayref
BTW and slight OT, I gave up on "fetching" a couple of years ago after I read gmax's wonderful DBI Recipes. No prepping or executing needed.
my $stmt = qq/SELECT * FROM mytable WHERE id = ?/; my $result = $dbh->selectall_arrayref($stmt, {Slice => {}}, $subscribe +r_id);
You end up with an AoH, which is perfect for me as I'm usually populating a loop in HTML::Template
|
|---|