fetchrow_hashref Confusion

Angel has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
(jeffa) Re: fetchrow_hashref Confusion by jeffa (Bishop) on Jun 15, 2002 at 18:05 UTC
By de-referencing: `my %hash = %{$sth->fetchrow_hashref()};` [download] But you don't have to do that ... you could do something like: `while (my $row = $sth->fetchrow_hashref()) { my $mail = $row->{mail}; print "$mail\n"; }` [download] just as easily IMHO. jeffa L-LL-L--L-LL-L--L-LL-L-- -R--R-RR-R--R-RR-R--R-RR B--B--B--B--B--B--B--B-- H---H---H---H---H---H--- (the triplet paradiddle with high-hat)	[reply] [d/l] [select]
Re: fetchrow_hashref Confusion by runrig (Abbot) on Jun 15, 2002 at 18:18 UTC
How to I get at the hash it's self and not the reference? The same way you work with any other hash ref: `%hash = %$hashref; # or to get at a specific value: $value = $hashref->{key}; # or you can use fetchrow_arrayref: my @names = @{$sth->{NAME_lc}}; my %hash; while (my $values = $sth->fetchrow_arrayref) { @hash{@names} = @$values; }` [download]	[reply] [d/l]
Re: fetchrow_hashref Confusion by VSarkiss (Monsignor) on Jun 16, 2002 at 00:09 UTC
Two excellent specific answers to your question from jeffa and runrig are above. For more background, take a look at perlref and tye's very handy References quick reference.	[reply]