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/perl?unsub=lists@pantek.com

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek