"Peter J. Holzer" wrote

>or selectall_arrayhashref?

>Anyway, I rather frequently find that the "most natural" way to
>represent a query result is an array of hashes: Each row is hashref, but
>the the rows are in an array(ref) so that the order is preserved, and
>the columns can be accessed by name.

>Proposed use:

>my $emp = $dbh->selectall_hasharrayref("select * from emp order by ename");

>for (@$emp) {
>   print "$_->{ename} ($_->{empno}): $_->{job}\n";
>}

>or

>for ($first .. $last) {
>    print $emp->[$_]{ename}, "\n";
>}

>or something like that.

>What do you think?"

Would be sweet!! I have had the same idea myself as there are times when I
could really use such a function.
Would you like to work on it I have a few hours a day to commit to it?



Reply via email to