I have no found a good way to do GROUP BY queries or INNER JOIN's in cake. Was wondering if any of you have come across these and how you handled them. I have not been able to do either of them in conjunction with the find() method in any normal way.Perhaps I am missing something? I'd love to find out if I am. Are these some sort of database specific constructs?
With Group by, sometimes I can get away with appending $conditions[] = 'GROUP BY field'; annd the in addition to that, manually passing in the fields to find() and prepending DISTINCT to the id column. Inner Join I have seen zero support from in Cake. Any time I've wanted to Inner join I've had to write the query manually. You know, sometimes you just need to filter your queries based on two tables, not just your primary table. Any help on these issues would be greatly appreaciated. I know I am not the only one who has had trouble with them. --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---
