RE: What is the best way to use maxrows in fetchall_arrayref?

2002-08-14 Thread Fox, Michael
ject: Re: What is the best way to use maxrows in fetchall_arrayref? -- "Fox, Michael" <[EMAIL PROTECTED]> on 08/14/02 08:07:44 +1000 > > Any thoughts on using the new DBI feature, specifying maxrows in a > fetchall_arrayref? > > If I use something like >

Re: What is the best way to use maxrows in fetchall_arrayref?

2002-08-14 Thread Tim Bunce
On Tue, Aug 13, 2002 at 06:32:45PM -0400, [EMAIL PROTECTED] wrote: > > > > Any thoughts on using the new DBI feature, specifying maxrows in a > > fetchall_arrayref? > > > > If I use something like > > > > while ( my $array_ref=$sth->fetchall_arrayref(undef, $maxfetch)) { > > # ... do somethin

Re: What is the best way to use maxrows in fetchall_arrayref?

2002-08-13 Thread lembark
-- "Fox, Michael" <[EMAIL PROTECTED]> on 08/14/02 08:07:44 +1000 > > Any thoughts on using the new DBI feature, specifying maxrows in a > fetchall_arrayref? > > If I use something like > > while ( my $array_ref=$sth->fetchall_arrayref(undef, $maxfetch)) { > # ... do something > } See exa

What is the best way to use maxrows in fetchall_arrayref?

2002-08-13 Thread Fox, Michael
Any thoughts on using the new DBI feature, specifying maxrows in a fetchall_arrayref? If I use something like while ( my $array_ref=$sth->fetchall_arrayref(undef, $maxfetch)) { # ... do something } I get an inactive handle and an error on the last time through the loop. Currently I am using