http://qs321.pair.com?node_id=549247


in reply to Re: array references in DBI
in thread array references in DBI

Thank you for pointing this out. What if @an was lexical but declared before the while loop? I would have the same problem, no?

Replies are listed 'Best First'.
Re^3: array references in DBI
by bart (Canon) on May 15, 2006 at 11:35 UTC
    Yes, you would be pushing the same array ref every time, and the contents would change afterwards.

    Test code (no DBI involved): 

    my @rows;
my @row = qw(one two);
push @rows, \@row;
@row = qw(three four);

use Data::Dumper;
print Dumper \@rows;

__END__
$VAR1 = [
          [
            'three',
            'four'
          ]
        ];

    [download]

    As you can see, the contents of the collating array changes after you put it in there.

[reply]
[d/l]

In Section Seekers of Perl Wisdom