$this->Comment->find(
'first',
array(
'conditions' => array(
'Comment.id' => 121
),
'fields' => array(
'Comment.text',
'Comment.user_id'
),
'contain' => array(
'User' => array(
'fields' => array(
'User.name',
'User.skill',
'User.address_id'
),
'Address' => array(
'fields' => array(
'Address.street'
)
)
)
)
)
);
On Fri, Jul 31, 2009 at 2:04 AM, Veoempleo<[email protected]> wrote:
>
> Thank you very much,
>
> This solve my question. But usually DBs have complex relationships,
> for example, if I have more deep relationships:
>
> "Comment" --- (hasOne) ---> "User" --- (hasOne) --> Address
>
> How Is it possible retrieve information from Comment Controller like
> the next array structure (or something like this)?
>
> Array
> (
> [Comment] => Array
> (
> [id] => 121
> [text] => Text
> [user_id] => 2
> )
> Array
> (
> [User] => Array
> (
> [id] => 12
> [name] => Peter
> [skill] => Baking Cakes
> [adress_id] => 4
> )
> [Address] => Array
> (
> [id] => 4
> [street] => Elm Street
> )
> )
> )
>
>
>
> On Jul 30, 5:21 pm, JamesF <[email protected]> wrote:
>> seconded
>>
>> On Jul 30, 8:16 am, brian <[email protected]> wrote:
>>
>> > In addition to what James suggested, you should modify the Comment class:
>>
>> > class Comment extends AppModel {
>> > var $name = 'Comment';
>>
>> > var $belongsTo = array('User');
>>
>> > }
>>
>> > And give the comments table a user_id column (to match the type of
>> > users.id).
>>
>> > On Thu, Jul 30, 2009 at 1:02 AM, Veoempleo<[email protected]> wrote:
>>
>> > > Hello,
>>
>> > > I have a question after reading model developing.
>>
>> > > I have two models, user that has many comments. I define:
>>
>> > > <?php
>>
>> > > class User extends AppModel {
>> > > var $name = 'User';
>> > > var $hasMany = 'Comment';
>> > > }
>> > > ?>
>>
>> > > <?php
>>
>> > > class Comment extends AppModel {
>> > > var $name = 'Comment';
>> > > }
>> > > ?>
>>
>> > > From Comment controller, How I could retrieve User information from
>> > > Comment row?
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
