Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
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?
[holli]: Alone the chatterbox and everybody writes his own cb client tradition
[LanX]: there was a guy who tried to steal the concept and build an own monastery ...
[LanX]: yeah PM is very emacsy ;-)
[LanX]: I think tobyink was on a good track with his redesign, pitty the pmdevs/gods didn't try to continue the approach of a modern responsive design
[holli]: *sigh* why has there to be drama in such a thread?
[LanX]: ?
[holli]: Re^2: Let's Make PerlMonks Great Again! -- suggestions and dreams - STFU and write code already (start already)

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (7)
As of 2017-11-20 19:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:













    Results (292 votes). Check out past polls.

    Notices?