Beefy Boxes and Bandwidth Generously Provided by pair Networks
Come for the quick hacks, stay for the epiphanies.
 
PerlMonks  

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

by jdlev (Scribe)
on Sep 09, 2013 at 20:58 UTC ( [id://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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1053094]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chilling in the Monastery: (2)
As of 2024-04-26 00:47 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found