Well thanks for the prompt reply....
I have this model Structure -
Model 1 - Union
var $belongsTo = array(
'Address' => array(
'className' => 'Address',
'foreignKey' => 'address_id',
'conditions' => '',
'fields' => '',
'order' => ''
) );
Model 2 - Address
var $belongsTo = array(
'District' => array(
'className' => 'District',
'foreignKey' => 'district_id',
'conditions' => '',
'fields' => '',
'order' => ''
)
);
Model 3 District.
with fields name and code both varchar.
Now when I paginate UNION like this
$this->paginate = array(
'order' => array('Address.street' => 'ASC'),
);
it works fine.
What I need is the next level that is District which is related to Address,
but not to UNION
On Tue, May 4, 2010 at 1:39 PM, Andrei Mita <[email protected]> wrote:
> Check out the 2 links below:
> http://book.cakephp.org/view/164/Pagination
> http://book.cakephp.org/view/858/Using-Containable-with-pagination
>
>
>
> On Tue, May 4, 2010 at 11:07 AM, Andrei Mita <[email protected]>wrote:
>
>> I believe paginate documentation in the book has a similar example.
>>
>>
>>
>> On Tue, May 4, 2010 at 9:48 AM, sijo jose <[email protected]> wrote:
>>
>>> Hi guys,
>>>
>>> I have this model Structure -
>>>
>>> Model 1 - Union
>>>
>>> var $belongsTo = array(
>>> 'Address' => array(
>>> 'className' => 'Address',
>>> 'foreignKey' => 'address_id',
>>> 'conditions' => '',
>>> 'fields' => '',
>>> 'order' => ''
>>> ) );
>>>
>>>
>>> Model 2 - Address
>>>
>>> var $belongsTo = array(
>>> 'District' => array(
>>> 'className' => 'District',
>>> 'foreignKey' => 'district_id',
>>> 'conditions' => '',
>>> 'fields' => '',
>>> 'order' => ''
>>> )
>>> );
>>>
>>> Model 3 District.
>>> with fields name and code both varchar.
>>>
>>>
>>> Now I would like to paginate the Unions which should be ordered in ASC by
>>> Union.Address.District.name ASC
>>>
>>> Is that possible and if so how should i write the paginate.
>>>
>>> Urgent help need. I am stuck here.
>>>
>>>
>>>
>>>
>>>
>>> Regards,
>>> --
>>> Sijo Jose Chakramakkil
>>>
>>> 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 [email protected]
>>> To unsubscribe from this group, send email to
>>> [email protected]<cake-php%[email protected]>For
>>> more options, visit this group at
>>> http://groups.google.com/group/cake-php?hl=en
>>>
>>
>>
> 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 [email protected]
> To unsubscribe from this group, send email to
> [email protected]<cake-php%[email protected]>For
> more options, visit this group at
> http://groups.google.com/group/cake-php?hl=en
>
--
Sijo Jose Chakramakkil
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 [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
