Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw

fetchrow_hashref Confusion

by Angel (Friar)
on Jun 15, 2002 at 17:39 UTC ( #174853=perlquestion: print w/ replies, xml ) Need Help??
Angel has asked for the wisdom of the Perl Monks concerning the following question:

How to I get at the hash it's self and not the reference? I need the hash that it returns to get at the data for a mail merge project?

Comment on fetchrow_hashref Confusion
(jeffa) Re: fetchrow_hashref Confusion
by jeffa (Chancellor) on Jun 15, 2002 at 18:05 UTC
    By de-referencing:
    my %hash = %{$sth->fetchrow_hashref()};
    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"; }
    just as easily IMHO.


    (the triplet paradiddle with high-hat)
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; }
Re: fetchrow_hashref Confusion
by VSarkiss (Monsignor) on Jun 16, 2002 at 00:09 UTC

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://174853]
Approved by virtualsue
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (13)
As of 2015-05-05 16:39 GMT
Find Nodes?
    Voting Booth?

    In my home, the TV remote control is ...

    Results (120 votes), past polls