Re: sql view table vs controller logic

2008-02-05 Thread Defranco
Hi thank you for the clarification and for the nice tips! regards Erico --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscr

Re: sql view table vs controller logic

2008-02-04 Thread [EMAIL PROTECTED]
I've done this with one of my apps, and it works pretty well. Beware of using any derived fields in your views though (like SUM(total)) - the mysql PHP drivers have a bug in them that prevents the correct field names from being seen by cakePHP for these fields. The one reason not to do the would

sql view table vs controller logic

2008-02-04 Thread Defranco
Hi all, Is acceptable to use a sql view table (a virtual sql table based on predefined permanent queries) instead a using a controller logic for a specific case? I have a complex query between several tables and looks like that would be too hard to do it using models relations and controller log