With the setup you have, wouldn't the profile come along for the ride
on your finds? I would expect to be able to get a returned array like
this:
array(
[0]
Post => post fields
User => user fields
Profile => profile fields
[1]
Post => post fields
User => user fields
Profile => profile fields
Regards,
Don
On May 12, 8:57 am, amiable_indian <[email protected]> wrote:
> I am having tough time trying to join two table which are not connected
> directly. For example:
>
> User hasOne Profile
> User hasMany Post
>
> I want to join Post and Profile (based on user_id which is common) and tried
> doing couple of things but none worked.
>
> * Firstly, I tried $hasOne in Post model with ( 'foriegnKey' => false,
> 'condition' => 'Post.user_id = Profile.user_id' ). That didn't worked.
> * Secondly, I tried using putting 'joins' in $conditions for
> $this->Post->find(...). That didn't worked either.
>
> Last option would be use raw_query, but I am trying to avoid using that.
>
> Any suggestions?
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
