I have three models Country, State and City
I have defined the relationships in the respective models.
class Country extends AppModel
{
var $name = 'Country';
var $hasMany = array
(
'States' => array (
'className' => 'State',
'foreignKey' => 'countries_id'
)
);
}
class State extends AppModel
{
var $name = 'State';
var $belongsTo = array
(
'Country' => array (
'className' => 'Country',
'foreignKey' => 'countries_id'
),
);
var $hasMany = array
(
'Cities' => array (
'className' => 'City',
'foreignKey' => 'states_id'
),
);
}
class City extends AppModel
{
var $name = 'City';
var $belongsTo = array
(
'State' => array (
'className' => 'State',
'foreignKey' => 'states_id'
),
);
}
In the StatesController, for pagination i have given the following
condition
var $paginate = array(
'limit' => 20,
'order' => array(
'State.name' => 'asc'
),
'recursive' => 2
);
And i call the paginate like this:
$states = $this->paginate('State');
Still i am not able to get the country columns. Can someone suggest me
what is happening and why the recursive is not loading the country
object. i have tried all the soultions i found on the net. Still not
able to get a solutions for the same. Does this behave differently in
linux and windows??.
I have to load the State and City object when i paginate cities also
next. Any solution?? Any solution will be helpful. Thanks.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
