Re: Help with complex find() spanning several models

2008-10-31 Thread 33rtp
Awesome. Thanks. On Oct 31, 4:37 pm, teknoid <[EMAIL PROTECTED]> wrote: > By default joins are only built for hasOne or belongsTo. > Here's how to "trick" cake into building joins for deep model > bindings:http://teknoid.wordpress.com/2008/07/17/forcing-an-sql-join-in-cakephp/ > > there is anoth

Re: Help with complex find() spanning several models

2008-10-31 Thread teknoid
By default joins are only built for hasOne or belongsTo. Here's how to "trick" cake into building joins for deep model bindings: http://teknoid.wordpress.com/2008/07/17/forcing-an-sql-join-in-cakephp/ there is another post on my blog if you search, which has a slightly more advanced example of th

Re: Help with complex find() spanning several models

2008-10-31 Thread 33rtp
Thanks for the help teknoid. I've done that, and I think there are some possibilities there, but they are a little longer than I'd like. For those who might come after this and not feel like reading the full situation above, my question in a nut-shell really is: How do you run a find on a field

Re: Help with complex find() spanning several models

2008-10-31 Thread 33rtp
On Oct 31, 3:28 pm, teknoid <[EMAIL PROTECTED]> wrote: > That's a lot to read, but I can point you in the direction of checking > out the Containable behavior (in the manual). > ... as well as really carefully reading up on the model associations > and data retrieval. > > On Oct 31, 2:30 pm, 33r

Re: Help with complex find() spanning several models

2008-10-31 Thread teknoid
That's a lot to read, but I can point you in the direction of checking out the Containable behavior (in the manual). ... as well as really carefully reading up on the model associations and data retrieval. On Oct 31, 2:30 pm, 33rtp <[EMAIL PROTECTED]> wrote: > Hey all... > > New to PHP, Cake, and

Help with complex find() spanning several models

2008-10-31 Thread 33rtp
Hey all... New to PHP, Cake, and MySQL so bear with me. I've been searching high and low for the best way to make this query work, but just haven't gotten it yet. Here's my setup: I have models for Users, Subscriptions, Authors, and Posts where: User HasMany Subscription (pk_User.id, fk_Subscr