Re: DBI:mysql does not return any value

Hi,

What do you get if you remove the 'select ... FOUND_ROWS..' ?

Patrick

Thomas Goik wrote:

> 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
>
>
>
>
>


-- 
Patrick Galbraith, Senior Programmer 
Grazr - Easy feed grazing and sharing
http://www.grazr.com 

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad




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