Your skill will accomplish what the force of many cannot |
|
PerlMonks |
Re: Retrieving data from db with foreign keysby CountZero (Bishop) |
on Sep 07, 2015 at 16:01 UTC ( [id://1141272]=note: print w/replies, xml ) | Need Help?? |
You have to understand that a foreign key in a table is actually a so-called "constraint". In other words it limits the content of that field to something that already exists in the table the foreign key refers to. It does not automatically retrieve that corresponding info for you. You will have to do that yourself through your query. One possible SQL statement is:
There are some modules that make handling foreign key fields somewhat easier. You may wish to have a look at DBIx::Class and more specifically DBIx::Class::Relationship that handles many-to-many relationships (which is what you are trying to do). CountZero A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James My blog: Imperial Deltronics
In Section
Seekers of Perl Wisdom
|
|