Re: Pagination Sort

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 <andrei.mita@gmail.com> 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 <andrei.mita@gmail.com> wrote:

I believe paginate documentation in the book has a similar example.

On Tue, May 4, 2010 at 9:48 AM, sijo jose <jose.sijo@gmail.com> 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 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

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

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