I have a complex database view that includes a large amount of joins (6) and aggregation functions (eg. SUM). I know this already breaks the MVC pattern, but I can't even imagine how it could be efficiently implemented using Model relationships.
I have successfully implemented a read-only page of the database view using the "QUERY" function. However, I am unable to use the Paginate functionality with this approach. Is it valid to create a Model of the database view? What issues are associated with this approach? Thanks for any feedback in advance. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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?hl=en -~----------~----~----~----~------~----~------~--~---
