Are you _certain_ that you're using DBI 1.30 and not 1.26?

Tim.

On Fri, Aug 09, 2002 at 01:04:42PM -0700, Eric Frazier wrote:
> 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