The stupid question is the question not asked | |
PerlMonks |
Class::DBI - Sorting by key in related table.by rlb3 (Deacon) |
on Apr 24, 2005 at 20:25 UTC ( [id://451026]=perlquestion: print w/replies, xml ) | Need Help?? |
rlb3 has asked for the wisdom of the Perl Monks concerning the following question:
Hello,
I not sure how to do this and maybe someone here can help. I the actual database there are five tables but only want to deal with two in this example. I have a table called IssuedKey that is a linking table. I looks something like:
I want to create a report of the people, who authorized, what building, and when they got the key, but I want to order by lname in the person table.
And to add more confusion, I want to use Class::DBI::Plugin::Pager to divide the results by pages. Can someone point me in the right direction. Thanks,
Back to
Seekers of Perl Wisdom
|
|