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