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

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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://231407]
help
Chatterbox?
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
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Perl 7 will be out ...





    Results (104 votes). Check out past polls.

    Notices?