Hi Allan, I´ve worked with what you describe before, although a number of years ago now.
Isn´t UNION what you are looking for? You would just override your findAll method in your abstract class to execute (SELECT * FROM BigExecs WHERE $something) UNION (SELECT * FROM RoundExecs WHERE $something) ORDER BY $commonField LIMIT 10; Not sure how to do that a cake way, perhaps there is no cake way (comments?). You would want to include a check on the model name in the abstract findAll method defenition, such that child classes that inherit this method would execute the findAll method from Model, and not the abstract class method, but other than that... HTH, AD7six --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~----------~----~----~----~------~----~------~--~---
