Re: DBI:mysql does not return any value

Hi Yair;

>May be your perl version is old, the last working versions are 5.6 and 5.8.
>If the modules are new versions working into an old

perl -V
Summary of my perl5 (revision 5 version 8 subversion 4) ...

This is not my case

Thanks, any other idea!

Ciao Thomas

-----Original Message-----
From: Thomas Goik [mailto:liste@mi-espacio.com] Sent: Tuesday, August 14, 2007 1:16 PM
To: perl@lists.mysql.com
Subject: DBI:mysql does not return any value

Hello;

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

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=yairl@savion.huji.ac.il 



-- 
MySQL Perl Mailing List
For list archives: 
http://lists.mysql.com/perl
To unsubscribe:    
http://lists.mysql.com/perl?unsub=lists@pantek.com