Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Re: Passing a hash between subs

by physi (Friar)
on Jan 30, 2003 at 18:45 UTC ( #231407=note: print w/replies, xml ) Need Help??

in reply to Passing a hash between subs

In bar(), $idand $location, which fills your %location hash, are values and no references to anything.
I think that they are the values from coloum 'id' and 'location' from your database !!!

So if you want to get the location for i.e. id=4 you have to write  $location{4}
But all in all you can do it a bit more easier I think:

use DBI; my %location = map { $_->[0] => $_->[1] } @{$dbh->selectall_arrayref( +'select id, location from ndmw_location')};
There's also a $dbh->selectall_hashref() possibility, but I can't figure out, how it works ;-)
Maybe perlodoc DBI can help ?

Hope this helps ?

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://231407]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2021-05-10 07:08 GMT
Find Nodes?
    Voting Booth?
    Perl 7 will be out ...

    Results (104 votes). Check out past polls.