in reply to yet more dbi issues

The part of your code where you fill in the array of arrays could be written far more efficiently like this:

my @list_of_teamdata; while (my @row = $sth5->fetchrow_array()) { push @list_of_teamdata, \@row; }

As for your "uninitialised value" error, I'd look at the database and make sure you don't have any null values in the teamname column.

--
<http://www.dave.org.uk>

"Perl makes the fun jobs fun
and the boring jobs bearable" - me

Replies are listed 'Best First'.
Re: Re: yet more dbi issues
by runrig (Abbot) on Apr 03, 2001 at 21:47 UTC
    Or just use fetchall_arrayref (or selectall_arrayref):
    my @list_of_teamdata = @{$sth->fetchall_arrayref}; # or just rewrite the rest to use an array ref my $list_of_teamdata = $sth->fetchall_arrayref;