Hi,

I can't figure out what could be causing this, but I am pretty certain that 
it is a Freebsd related to DBI issue.

I have FreeBSD 4.5 stable, mysql 4.0.1, DBI 1.30  both installed from 
ports, and DBD::mySQL 2.0416

The problem is when I use fetchall_arrayref  the last column is empty.

for Example:


Assuming you have a connection handle...


$cust_name_qu = "select cu_email,cu_firstname,cu_lastname from customer 
limit 1000,10";

my $sth = $dbh->prepare($cust_name_qu);
$sth->execute();

  my $rows    = $sth->fetchall_arrayref();

    my($i, $j);
           for $i ( 0 .. $#{$rows} ) {
               for $j ( 0 .. $#{$rows->[$i]}) {
                   print "$rows->[$i][$j]\t";
               }
                 print "  i:$i j:$j\n\n";
           }

I get output like this:


[EMAIL PROTECTED] Scott     i:0 j:

[EMAIL PROTECTED]    John H    i:1 j:

[EMAIL PROTECTED]      SCOTT W   i:2 j:

[EMAIL PROTECTED]   WANG      i:3 j:

[EMAIL PROTECTED]  Soh Chau          i:4 j:

[EMAIL PROTECTED]      Bryan G   i:5 j:

[EMAIL PROTECTED]     Clark     i:6 j:

[EMAIL PROTECTED]   Chern-Hoong       i:7 j:

[EMAIL PROTECTED]    Leslie K          i:8 j:

[EMAIL PROTECTED]     Russell M         i:9 j:


I am missing the lastname, I tried this with various different queries and 
found it is consistent, if I use fetchrow_arrayref then I get the lastname 
column correctly. If I do this on Linux slackware, all is well, I get my 
lastname column.


Prayers and chicken sacrafices welcome,

Eric




Leading Edge Marketing Inc.
250-360-2992

Reply via email to