Thanks Tim, that worked fine.
I would like to suggest enhancing at least this selectall_arrayref
paragraph in the DBI perldocs to include an example or two about
how to use Columns and Slice attributes:
The the fetchall_arrayref entry elsewhere in this
documentmethod called by selectall_arrayref supports a
$slice parameter. You can specify a value for $slice
by including a 'Slice' or 'Columns' attribute in
\%attr. The only difference between the two is that if
Slice is not defined and Columns is an array ref, then
the array is assumed to contain column index values
(which count from 1), rather than perl array index
values. In which case the array is copied and each
value decremented before passing to
/fetchall_arrayref.
Thanks again.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
Tim Bunce [[EMAIL PROTECTED]] wrote:
> On Tue, Sep 11, 2001 at 03:31:31PM -0400, Hardy Merrill wrote:
> > I've read the DBI perldocs and can't find an example of how to
> > use selectall_arrayref with the Columns attribute - I want to
> > retrieve all the rows in a select into an array of hashref's,
> > and I want ALL columns - do I need to specify the Columns
> > attribute and list *every* column?
>
> No, use:
>
> { Columns => {} }
>
> Please reread the docs and let me if they're not clear enough.
>
> Tim.
