Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re^2: How to add MySql Records To Array or Hash?

by jdlev (Scribe)
on Sep 09, 2013 at 20:58 UTC ( #1053094=note: print w/ replies, xml ) Need Help??


in reply to Re: How to add MySql Records To Array or Hash?
in thread How to add MySql Records To Array or Hash?

That looks a lot like what I'm looking for. It says in the DBI documentation that the $key_fields should be called as an array if you want to call multiple columns. Any idea on how to do that? I haven't been able to find any example :(

I love it when a program comes together - jdhannibal


Comment on Re^2: How to add MySql Records To Array or Hash?
Re^3: How to add MySql Records To Array or Hash?
by McA (Curate) on Sep 09, 2013 at 22:00 UTC

    You don't need it IMHO as you have ID as primary key, so just set $key_fields to the field name 'ID'.

    One thing you have to be aware of is the case of the identifier. Look at NAME_uc and NAME_lc in the DBI documentation.

    Regards
    McA

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (4)
As of 2014-08-01 10:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Who would be the most fun to work for?















    Results (4 votes), past polls