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
>