Hi,
I am trying to get the selectall_hashref() method to work. I have a table
called "youthLeader", with columns "fname" and "lname". I want to retrieve
all the rows in one shot and then output each row (eventually I want to feed
this to the looping construct in HTML::Template). Any clues as to what I'm
doing wrong?
Here's my code...
my $dbh = DBI->connect("DBI:mysql:infomgr", undef, undef) or die "Can't
connect: " . $DBI::errstr;
my $matrix = $dbh->selectall_hashref("SELECT * FROM youthLeader");
print "value 2 = " . $matrix->[1]{fname} . "\n";
$dbh->disconnect;
and here's the error message I'm getting...
[Tue Dec 18 20:29:39 2001] yltest.pl: Use of uninitialized value in hash
element at C:/Perl/site/lib/DBI.pm line 1205.
[Tue Dec 18 20:29:39 2001] yltest.pl: Use of uninitialized value in
concatenation (.) or string at C:/Perl/site/lib/DBI.pm line 1208.
[Tue Dec 18 20:29:39 2001] yltest.pl: DBD::mysql::db selectall_hashref
failed: Field '' does not exist (not one of fname lname) at yltest.pl line
26.
[Tue Dec 18 20:29:39 2001] yltest.pl: Use of uninitialized value in
concatenation (.) or string at yltest.pl line 27.
BTW, I'm using DBI v1.20 on ActiveState Perl 5.6.1.630 on Windows XP.
Thanks.
Jani
