> From: Tim Bunce [mailto:[EMAIL PROTECTED]]
>
> If it's not documented in the latest release then send me a patch :)
Here ya go (plus a miscellaneous typo fix):
"DBI.pm" 4434 lines, 159535 characters
stan:~/src/DBI-1.20 >diff -ruN DBI.orig DBI.pm
--- DBI.orig Tue Sep 11 15:45:19 2001
+++ DBI.pm Tue Sep 11 16:51:13 2001
@@ -34,8 +34,9 @@
$ary_ref = $dbh->selectcol_arrayref($statement);
$ary_ref = $dbh->selectcol_arrayref($statement, \%attr);
- $ary_ref = $dbh->selectrow_arrayref($statement);
- @row_ary = $dbh->selectrow_array($statement);
+ $ary_ref = $dbh->selectrow_arrayref($statement);
+ @row_ary = $dbh->selectrow_array($statement);
+ $hash_ref = $dbh->selectrow_hashref($statement);
$sth = $dbh->prepare($statement);
$sth = $dbh->prepare_cached($statement);
@@ -2371,6 +2372,36 @@
a scalar context should be used with caution.
+=item C<selectrow_arrayref>
+
+ $ary_ref = $dbh->selectrow_array($statement);
+ $ary_ref = $dbh->selectrow_array($statement, \%attr);
+ $ary_ref = $dbh->selectrow_array($statement, \%attr, @bind_values);
+
+This utility method combines L</prepare>, L</execute> and
+L</fetchrow_arrayref> into a single call. It returns the first row of
+data from the statement. The C<$statement> parameter can be a previously
+prepared statement handle, in which case the C<prepare> is skipped.
+
+If any method fails, and L</RaiseError> is not set, C<selectrow_array>
+will return undef.
+
+
+=item C<selectrow_hashref>
+
+ $hash_ref = $dbh->selectrow_hashref($statement);
+ $hash_ref = $dbh->selectrow_hashref($statement, \%attr);
+ $hash_ref = $dbh->selectrow_hashref($statement, \%attr, @bind_values);
+
+This utility method combines L</prepare>, L</execute> and
+L</fetchrow_hashref> into a single call. It returns the first row of
+data from the statement. The C<$statement> parameter can be a previously
+prepared statement handle, in which case the C<prepare> is skipped.
+
+If any method fails, and L</RaiseError> is not set, C<selectrow_hashref>
+will return undef.
+
+
=item C<selectall_arrayref> I<NEW>
$ary_ref = $dbh->selectall_arrayref($statement);
@@ -3481,7 +3512,7 @@
index number (starting at 0, unlike column and parameter numbers which
start at 1).
-With no parameters, C<fotchall_arrayref> acts as if passed an empty array
ref.
+With no parameters, C<fetchall_arrayref> acts as if passed an empty array
ref.
When passed a hash reference, C<fetchall_arrayref> uses
L</fetchrow_hashref>
to fetch each row as a hash reference. If the parameter hash is empty then
