Re: DBI::fetchall_arrayref() error

According to DBI::Changes, the option to pass a limit to the rowcount as a second parameter is added in DBI 1.26.

Changes in DBI 1.26, 13th June 2002
Added $max_rows parameter to fetchall_arrayref() to optionally limit the number of rows returned. Can now fetch batches of rows.

Me, as being one of the people who noticed this error, am still using DBI 1.21.

I hate having to upgrade everything every few months — especially if everything else works very well.

Update: In case anyone wonders, I was referring to this sentence:

But some people even seem to get these errors with the undef in there!

Comment on Re: DBI::fetchall_arrayref() error

Replies are listed 'Best First'.
Re: Re: DBI::fetchall_arrayref() error by pg (Canon) on Jan 12, 2004 at 01:21 UTC
I even tried with 1.39, and the problem exists. The OP didn't do anything strange, that syntax he used is in DBI document. "limit the number of rows" This has nothing to do with number of rows, but number of columns. I tried: `$sth->fetchall_arrayref([0])`, it fails in the same way. This is a bug.	[reply] [d/l]
Re: Re: DBI::fetchall_arrayref() error by Anonymous Monk on Jan 11, 2004 at 23:30 UTC
still using DBI 1.21 But the OP is using DBI 1.38 that supports this feature, so the problem is somewhere else ...	[reply]