push(@newarray, $aryref);
foreach my $aryref (@newarray)
{
foreach my $elem (@{$aryref})
{
print "$elem\n";
}
}
or
print $newarray[0]->[1], "\n";
--- [EMAIL PROTECTED] wrote:
> 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
>
=====
Anthony Ettinger
[EMAIL PROTECTED]
http://www.apwebdesign.com
Instant Messengers:
1) yahoo im: apwebdesign 2) aol im: apwebdesignxl
3) msn im: [EMAIL PROTECTED] 4) icq im: 659139
__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail
_______________________________________________
Perl-Unix-Users mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs