Bug #77058 for DBI: Feature request: selectall_arrayref, etc, return the statement handle too

Tue May 08 06:50:46 2012 EDAVIS [...] cpan.org - Ticket created

Subject:

Feature request: selectall_arrayref, etc, return the statement handle too

Currently $dbh->selectall_arrayref returns a single scalar, which is an array reference of the results. It would be useful for it to return the statement handle too: ($ary_ref, $sth) = $dbh->selectall_arrayref($statement); The caller could then fish out statement attributes from $sth if wanted. In scalar context, it would still return just the results arrayref, so this would be backwards compatible. selectall_hashref and selectcol_arrayref should similarly return the sth.

Tue May 08 06:59:09 2012 bohica [...] ntlworld.com - Correspondence added

On Tue May 08 06:50:46 2012, EDAVIS wrote: Show quoted text

> Currently $dbh->selectall_arrayref returns a single scalar, which is

an Show quoted text

> array reference of the results. It would be useful for it to return

the Show quoted text

> statement handle too: > > ($ary_ref, $sth) = $dbh->selectall_arrayref($statement); > > The caller could then fish out statement attributes from $sth if

wanted. Show quoted text

> In scalar context, it would still return just the results arrayref, so > this would be backwards compatible. > > selectall_hashref and selectcol_arrayref should similarly return the

sth. I'm not totally sure the automatically created stmt in your example above is guaranteed to exist after selectall_arrayref returns. Just prepare the statement first and pass it to selectall_arrayref instead of the sql. Martin -- Martin J. Evans Wetherby, UK

Tue May 08 06:59:11 2012 The RT System itself - Status changed from 'new' to 'open'

Wed May 23 04:56:10 2012 TIMB [...] cpan.org - Correspondence added

Thanks for the suggestion, but Martin's explanation is correct.

Wed May 23 04:56:11 2012 TIMB [...] cpan.org - Status changed from 'open' to 'rejected'