Thanks Grigri, I've never tried that method, I'll have to check it out. It seems though like the dynamic bind model that you are setting up is just a mirror of the HasMany relationship that you had already setup in the model file. I wonder why then, it is necessary to give cake the same information it already has with the dynamic bindmodel command. It seems like it should work without it. This is a lot better than having to write custom SQL though. Thanks!
On Apr 29, 8:58 am, grigri <[EMAIL PROTECTED]> wrote: > I do it like this > :http://groups.google.com/group/cake-php/browse_thread/thread/863305f8... > > it works fine, even with lots of associated models. Doing `and` joins > (series must have genre 'bacon' AND genre 'eggs') is more longwinded > because you have to perform a separate join for each one, but it still > works fine. > > On Apr 29, 3:53 pm, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > wrote: > > > Yeah, I try to use the built in functionality as much as possible as > > well. I think that this particular issue is something that needs to be > > added in future releases though. I've tried using the bindmodel > > functions to add conditions to child models and then do a find on the > > parent but this doesn't seem to work either. When you bind a model on > > the fly, the binding only applies when you use that model to make the > > query, not when you query it through a parent model. So yeah, this > > seems like important functionality that really should be adressed. > > > On Apr 29, 1:35 am, Crazy <[EMAIL PROTECTED]> wrote: > > > > Thanks, I'll do a custom query then :), want to use the build in > > > functionallity of cakephp as much as possible :), still pretty new at > > > it. > > > > On 29 apr, 00:17, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> > > > wrote: > > > > > I've never found a good built in solution to this. Cake does generate > > > > join queries so perhaps you can look at the output of the query in the > > > > debugger and create conditions that would work with it (like what you > > > > are suggesting above). Otherwise, write a custom join query and use > > > > $this->Model->query($sql); to execute. More often than not, this is > > > > what I do for complex conditions like this. > > > > > Dave > > > > > On Apr 28, 3:23 pm, Crazy <[EMAIL PROTECTED]> wrote: > > > > > > I am wondering if it is possible to give conditions over multiple > > > > > related tables, currently I have this: > > > > > > Table series: > > > > > - id > > > > > - name > > > > > > Table genre_series: > > > > > - serie_id > > > > > - genre_id > > > > > > Table genres: > > > > > - id > > > > > - name > > > > > > Model is set up correctly with HABTM etc and when I do a findAll() I > > > > > get the correct output. > > > > > What I would like to do is something like this: > > > > > > findAll("Serie.name = 'somename' AND Genre.name = 'somegenre'"); > > > > > > How do I get something like this?, or do I have to use a custom SQL > > > > > query? --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
