Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
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?
Replies are listed 'Best First'.
Re^3: How to add MySql Records To Array or Hash?
by McA (Priest) 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 scrutinizing the Monastery: (17)
As of 2015-07-29 12:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (263 votes), past polls