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