no, I'm trying stuff like this:
$data = $this->User->find('all',
        array(
                'fields' => array('User.*', 'Invitation.*'),
                'conditions' => array(
                                'Invitation.id' => NULL
                ),
                'limit' => 100,
                'contain' => 'Invitation'
        )
);

but the resulting query does not JOIN with Invitation, so I get a
error on the WHERE condition...

I thought the LEFT JOIN was necessary, but the query works just fine
with JOIN. I still don't have the complete grasp on the different
joins, but I do understand they're not actually that different at all.

Anyways, I think that managing to get the join done will make the
query work, but I tried bindModel to add a hasOne relationship instead
of hasMany, and didn't work also.

Any more thoughts are appreciated! :)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"CakePHP" 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
-~----------~----~----~----~------~----~------~--~---

Reply via email to