DBI:mysql does not return any value

Hello;

I'm on a strange problem in my script i can't resolved by myself, so i hope 
that anybody has an idea.

The problem is that when i start a $dbh->prepare statement which will return 
more than X rows the result is -1. Exactly the same statement on mysql shell 
will return the result, in this case 1800 rows.

is there any limitation on the rows returned in DBI:mysql?
I connect from the machine where mysql is running

The statement will search inside of 1.800.000 items of its owners and this 
are 1800 .
The statement in the script is:
select SQL_CALC_FOUND_ROWS itSeller from tblItems where itClosedflag=0 
GROUP BY itSeller

$sth = $dbh->prepare(" $stats{$_}{where} ") || die $dbh->errstr ;
            $sth->execute();
            # is searching in the table
            print "\n" . $dbh->selectrow_array("select FOUND_ROWS()") . 
"\n";
            # 1800
            while($user_id = $sth->fetchrow_array()) {
            # nothing
            }

if i do so on mysql it will return the right numbers and rows.

max_allow_package = 80 MB
mysql version 5.0.32
Perl            : 5.008004    (i386-linux-thread-multi)
  OS              : linux       (2.6.15.6)
  DBI             : 1.46
  DBD::mysql      : 2.9006
  DBD::XBase      : 0.240
  DBD::Sponge     : 11.10
  DBD::Proxy      : 0.2004
  DBD::File       : 0.31
  DBD::ExampleP   : 11.12
  DBD::DBM        : 0.02

 



-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]