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