Thanks!
Tim.
On Tue, Sep 11, 2001 at 04:55:40PM -0700, Wilson, Doug wrote:
>
> > 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
