Here's another thing you can try: http://github.com/rafaelbandeira3/cakephp-plugins/tree/master/plugins/linkable_behavior/models/behaviors/linkable.php
This is a very nice behavior that will construct JOINs for you... There is a small example of usage in the comments of the code, in a way it is similar to Containable (core behavior) so you can review the manual to get the idea of how to use them. On Dec 19, 9:59 am, Martin Westin <[email protected]> wrote: > Hi dev, > Since Cake does not join on hasMany, you have a few options. > > You can use containable and then filter the resulting array. This > works until the returned dataset starts growing. You are likely to run > out of memory of at least slow things down a lot. > > You can join them yourself in a custom find. There is a little-known > key called "joins" where you can specify joins. Best bet is to look at > the api and the tests to learn more about it. > > Those are the alternatives I have used when I have had similar > problems. > Martin > > On Dec 19, 10:53 am, dev <[email protected]> wrote: > > > i posted code here:http://bin.cakephp.org/saved/40741 > > > How to join Image and Option tables if i want to set these find > > conditions in Advert? > > > I tried Containable (test2 function), but it selects all Adverts, and > > if i set conditions in first paginate array - it generates the same > > error, bicause tables don't join. > > > How to solve this problem? > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
