P is for Practical | |
PerlMonks |
Finer points of Class::DBIby rlb3 (Deacon) |
on Sep 13, 2004 at 21:50 UTC ( [id://390671]=perlquestion: print w/replies, xml ) | Need Help?? |
rlb3 has asked for the wisdom of the Perl Monks concerning the following question:
Hello Monks,
For the last couple of months I have been trying to understand the Class::DBI module. Slowly I've started to use it in some of my projects. The problem I'm having is learning the finer points of the module. For example, lets say I have a database with two tables. The first table Areas has a has_many relationship with the Stats table. Now for the project I want to create a report with all the stats organized by Areas. So the code would look something like: This would print out something like: Well thats all fine and good unless I want only the stats from August(8). I'm not sure how to do this without grabing all the stats for an area then using something like grep to get only the stats I want. I'm sure there is a better way to do it, but I'm just not seeing it. Any help would be great. rlb3
Back to
Seekers of Perl Wisdom
|
|