Re: Does anybody know how can I limit the join table fields when I user joins condition?

Sorry, the example is not appropriate. How about this?

Tag table:
id | name

Task table:
id | user_id | name

I want get all the tasks of a tag.

On Thu, Apr 2, 2009 at 12:31 AM, francky06l <francklemp@gmail.com> wrote:

Looking at your user/task description Isn'it a simple User hasMany
Task ? In such case, containable can do the job  ..
unless I am missing something

On Apr 1, 2:58 pm, joshua <josh...@gmail.com> wrote:
> Yes, we can use containable to get the task's users. But if there is a user
> , I want to find all the tasks he owns. How can I do?
>
> User table:
> id | name
>
> Task table:
> id | user_id | name
>
> We can't count on containable to help us to find the relate tasks. And I
> count on 'join' to  help me to do this. Any suggestions?
>
>
>

> On Wed, Apr 1, 2009 at 2:09 AM, Amit <a...@amitvaria.com> wrote:
>
> > I highly recommend checking out the Containable behavior:
>
> >http://book.cakephp.org/view/474/Containable
>
> > It will simplify this code and let you easily add fields.
>
> > On Mar 31, 8:28 am, joshua <josh...@gmail.com> wrote:
> > > For example:
> > > One task has many users.
> > > ########################
> > >         $condition = array();
> > >         $condition['joins'] = array(
> > >             array(
> > >                 'table' => 'users',
> > >                 'alias' => 'User',
> > >                 'type' => 'inner',
> > >                 'foreignKey' => 'user_id',
> > >                 'conditions'=> array('User.id =
> > > Task.user_id','User.deleted=0')
> > >         ));
> > > ########################
> > > I just want to find the user name , not all the fields in User table. I
> > try
> > > to add the 'fields' property in this array, but it seems not.
> > > --
> > > Thanks
> > > Joshua
>
> --
> Thanks
> Joshua

--
Thanks
Joshua

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---