Issue getting deeper info

I am trying to get the name of the child Locations from my Domain controller.

Here is the domain model:

class Domain extends AppModel {
    var $name = 'Domain';
    var $actsAs = array('Tree');
    var $displayField = 'name';
   
    var $belongsTo = array(
        'ParentDomain' => array(
            'className' => 'Domain',
            'foreignKey' => 'parent_id'
        ),
            'ConfirmedUser' => array(
                'className' => 'User',
                'foreignKey' => 'confirmed_id'
            ),
         );

    var $hasMany = array(
            'ChildLocations' => array(
                'className' => 'DomainsLocation',
                  'foreignKey' => 'domain_id'
            ),
            'ChildDomains' => array(
                'className' => 'Domain',
                  'foreignKey' => 'parent_id'
            ),
        );
}


This is my Location model:
class Location extends AppModel {
    var $name = 'Location';
    var $actsAs = array('Tree');
    var $displayField = 'name';

    var $belongsTo = array(
        'ParentLocation' => array(
            'className' => 'Location',
            'foreignKey' => 'parent_id'
        ),
            'ConfirmedUser' => array(
                'className' => 'User',
                'foreignKey' => 'confirmed_id'
            ),
         );

    var $hasMany = array(
            'ChildLocation' => array(
                'className' => 'Location',
                  'foreignKey' => 'parent_id'
            ),
            'ParentDomains' => array(
                'className' => 'DomainsLocation',
                  'foreignKey' => 'location_id'
            ),
        );
}


And this is the Join table for the two:

class DomainsLocation extends AppModel {
    var $name = 'DomainsLocation';
    var $belongsTo = array('Domain', 'Location');
}


So I am trying to get to the name of the Location that has been assigned to the Domain. This is the find command that I am using in my controller:

$domainInfo = $this->Domain->find('first', array( 'conditions'=>array('Domain.id' => $domainId) ) );


This is what I get when I print the results of $domainInfo:

 Array
(
    [0] => Array
        (
            [Domain] => Array
                (
                    [name] => Prime
                    [parent_id] => 
                    [description] => This is the global domain
                     [confirmed_id] => 1
                    [type] => 0
                    [modified] => 2010-09-22 15:17:13
                    [id] => 1
                )

            [ChildLocations] => Array
                 (
                    [0] => Array
                        (
                            [id] => 0
                            [domain_id] => 1
                            [location_id] => 2
                             [created] => 2010-09-28 15:29:33
                            [modified] => 2010-09-28 15:29:33
                        )

                )

            [ChildDomains] => Array
                 (
                    [0] => Array
                        (
                            [id] => 6
                            [parent_id] => 1
                            [lft] => 2
                             [rght] => 5
                            [confirmed_id] => 
                            [name] => United Kingdom
                            [type] => 1
                            [description] => This domain contains all of the United Kingdom.
                             [created] => 2010-09-17 04:21:18
                            [modified] => 2010-09-22 15:17:13
                        )

                )

            [children] => Array
                 (
                )

        )

)

As you can see, I am getting the location_id but I am not getting the name of that location and I do not want to have to do a separate search for each location. Any idea what I am doing wrong? Thanks.


~Michael

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.
 
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