(noob) trouble with belongsTo from another controller

Hi,

I'm a CakePHP noob who is converting a site from Fusebox/ColdFusion to
CakePHP (1.2.x). Without boring anyone with the domain details, I want
to output a list of 'allies' and their associated organizations
(belongs to an organization in the model). The problem I am running
into is that I cannot get CakePHP to recognize the relationship
between Allies and Organizations from a "third-party" controller (the
"HomeController").

Here's my setup:

MODEL:
FILENAME: ally.php
class Ally extends AppModel {

var $name = 'Ally';

//The Associations below have been created with all possible keys,
those that are not needed can be removed
var $belongsTo = array(
'Organization' => array(
'className' => 'Organization',
'dependent' => true,
'foreignKey' => 'organization_id'
)
);
}

FILENAME: organization.php
class Organization extends AppModel {

var $name = 'Organization';
var $displayName = 'name';

//The Associations below have been created with all possible keys,
those that are not needed can be removed
var $belongsTo = array(
'OrganizationType' => array(
'className' => 'OrganizationType',
'foreignKey' => 'organization_type_id'
)
);

var $hasMany = array(
'Ally' => array(
'className' => 'Ally',
'foreignKey' => 'organization_id'
)
);

}

CONTROLLER:
FILENAME: home_controller.php
class HomeController extends AppController
{
var $name = 'Home';
var $uses = array( 'Allies');

function index()
{
$allies = $this->Allies->find( 'all' );
$this->set( 'allies', $allies );
}

}

DB:
The tables (allies and organizations) are plural and both have a
primary key named 'id". The allies table has a column called
'organization_id' to act as a foreign key (MySQL 5 DB).

RESULTING SQL IN DEBUG OUTPUT:
SELECT `Allies`.`id`, `Allies`.`organization_id`, `Allies`.`sfa_href`,
`Allies`.`logo`, `Allies`.`overview`, `Allies`.`active` FROM `allies`
AS `Allies` WHERE 1 = 1

Why wouldn't this setup/configuration result in the allies select
trying to join the organizations table from the home controller?

It does work properly when I set it up from the Allies controller in
that I see both Ally data and Organization data. I'm just a little
stumped as to how to make this work from the HomeController.

Any help or guidance would be much appreciated.

Thanks!
Craig

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