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 -~----------~----~----~----~------~----~------~--~---
