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

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