Here's what I eventually did:
$userArray = $this->User->find('User.id='.$this->User->id, null, null,
1);
$this->set('data', $userArray);
foreach($userArray['Friends'] as $friend) {
$friendIds[] = $friend['id'];
$friendConditions = array('Profile.user_id' => $friendIds);
$this->set('friends', $this->User->Profile-
>findall($friendConditions));
}
This gave me two arrays that I could use to match the friends'
profiles to the users. It's a bit roundabout but it worked.
Chris
On Jan 20, 12:13 am, Chris Wade <[EMAIL PROTECTED]> wrote:
> A little more information.
>
> I've tried the following:
> $this->set('friends',
> $this->User->Friends->findall('user1_id='.$this->User->id));
>
> SQL Error: 1054: Unknown column 'user1_id' in 'where clause'
>
> $this->set('friends',
> $this->User->Friends->findall('Friends.user1_id='.$this->User->id));
>
> SQL Error: 1109: Unknown table 'Friends' in where clause
>
> $this->set('friends',
> $this->User->Friends->findall('users_users.user1_id='.$this->User->id));
>
> SQL Error: 1109: Unknown table 'users_users' in where clause
> (the table does exist)
>
> There is no 'Friends' model - it's just the User model attached to
> itself through a HABTM relationship (described in my last post).
> The 'models' chapter of the manual only describes how to query this
> sort of relationship using recursion. I'm trying to get it to find
> the user's friends directly, but I can't figure out how to get it to
> understand that it needs to look in the join table for the
> relationship.
>
> Am I missing something obvious? Do I need to clarify what I'm trying
> to do?
>
> Thanks again,
> Chris
>
> On Jan 19, 1:34 pm, Chris Wade <[EMAIL PROTECTED]> wrote:
>
> > Ah, Chaining was the word I was looking for, but I was thinking that
> > it would give you only the records from the chained models that were
> > related to the model of the controller you were in. Thanks for the
> > info.
>
> > So, to do something like what I want to do, I would have to say
> > $this->User->Friends->findall([set conditions to find the friends related to
>
> > the user]).
>
> > The 'Friends' relationship is a HABTM relating one user directly to
> > another through a table called users_users, which has the fields
> > 'user1_id' and 'user2_id'.
>
> > In the user model:
> > var $hasAndBelongsToMany = array('Friends' =>
> > array('className' =>
> > 'User',
> > 'joinTable' =>
> > 'users_users',
> > 'foreignKey' =>
> > 'user1_id',
> > 'associationForeignKey' =>
> > 'user2_id',
> > 'conditions' =>
> > '',
> > 'order' =>
> > 'created DESC',
> > 'limit' =>
> > '5',
> > 'unique' =>
> > true,
> > 'finderQuery' =>
> > '',
> > 'deleteQuery' =>
> > ''
> > )
>
> > var $hasOne = array('Profile' =>
> > array('className' => 'Profile',
> > 'conditions' => '',
> > 'order' => '',
> > 'dependent' => true,
> > 'foreignKey' => 'user_id'
> > ),
>
> > Avatars for each user are contained in the user's profile. Given this
> > relationship, how would you go about writing a query that would grab
> > the avatars from the profiles for each of the current user's friends,
> > without picking up all of the other relationships (there are several
> > not mentioned here)?
>
> > Thanks for the help.
>
> > Chris
>
> > On Jan 19, 9:32 am, "Dardo Sordi Bogado" <[EMAIL PROTECTED]> wrote:
>
> > > Chaining isn't bad, but it only gives you a reference for the model,
> > > it doesn't set any conditions. You have to pass them manually to the
> > > findAll().
>
> > > You can unbind() the models you don't want to get on the findAll and
> > > set the recursion level that fits your needs. Also it is possible to
> > > set conditions dinamically on the associations through
> > > Model::bindModel();
>
> > > Also if you are using CakePHP 1.2 you can use the bindable behavior
> > > (thanks Mariano) to control your associations.
>
> > > HTH,
> > > - Dardo Sordi.
>
> > > On Jan 18, 2008 10:54 PM, the_woodsman <[EMAIL PROTECTED]> wrote:
>
> > > > Hi,
>
> > > > I'm not sure I fully understand your problem, but:
>
> > > > > I'd like to figure out how to do something like:
> > > > > $this->set('friends', $this->User->Friends->Profiles->findAll());
> > > > > This returns every profile in the system, not just those for the
> > > > > user's friends.
>
> > > > Your controller isn't tied to usingjust one Model, the $uses array of
> > > > the Controller can specify all the models you want:
>
> > > > var $uses=array('Profiles','User');
>
> > > > then you can start all yourqueriesfrom these models, no need to
> > > > chain them as above.
>
> > > > > how to access the specific data I want without doing 2 or 3
> > > > > levels of recursion on a find() for the user.
>
> > > > There are various ways to tweak Cakequeries, like setting the
> > > > recursion level, or which tables to join for any particular query.
>
> > > > Jan 18, 11:09 pm, Chris Wade <[EMAIL PROTECTED]> wrote:
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
