while ($ary = $sth->fetchrow_arrayref) {
push @newary, @{$ary};
}
$sth->finish;
if ($debugmode eq "on") {
$output->insert('end', $newary[0][0]); # (1) this will cause
"Cannot use string as an ARRAY ref."
foreach my $line (@newary) {
$output->insert('end', $line); # (2) this shows all
data from query
}
}
#
# If I use: push @newary, [EMAIL PROTECTED]; then comment (1) above works
# but then comment (2) above shows will output only every other
# column from the query data!?
#
# All I want to do is get the data into @newary and be able to pass
# a specific column as a parameter or output all the data to my
# text widget. I'm confused by the inconsistencies I create when
# working with fetchrow_arrayref.
_______________________________________________
Perl-Unix-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs