Hi, Maybe you provide more detailed info ? :)
Or use this as other method :

$sth = $dbh->prepare($query);
$sth->execute($query);
while (my $row = $sth->fetchrow_hashref()) {
   #use $row->{date} etc here.
}
[download]

This is a bit slowly than bind_column but more straight-forward and lazy :)