Re: overriding order by in paginate

before paginate() call:

$this->paginate = Set::merge($this->paginate,  
  array('Product'=>array(  
     'order' => array('Product.sortorder' => 'ASC')
)); 

On Tue, Dec 2, 2008 at 9:29 PM, Todd McGrath <todd.mcgrath@gmail.com> wrote:

Hi,

Question on multiple "order" clauses in paginatation.

Question setup:

In controller:
       var $paginate = array(
               'Product' => array(
                       'limit' => 15,
                       'order'=>array('Collection.name'=>'asc',
'Product.productnumber'=>'asc')
               )
       );

which works well when I want to paginate Product and order by
'Collection.name'=>'asc', 'Product.productnumber'=>'asc'.

Example function in this controller:
function product_types($typeId = null, $manId = null) {
       $this->set('products', $this->paginate('Product', array
( 'Product.channel_type_id'=>array
(2,3),'ProductsProductTypes.product_type_id'=>$typeId)));
}

But, in a different function _within the same controller_, I want to
order by Product.sortorder (a double field in products table):

function products($id = null, $manufacturerId= null) {
 $criteria = array('Product.collection_id'=>$id,
'Product.channel_type_id'=>array(2, 3)); // paging criteria
 $this->set('products', $this->paginate('Product', $criteria));
}

It doesn't appear I can change the order by clause in the "products"
function?  In other words, I seem to be stuck with the 'order' defined
at the class level (order'=>array('Collection.name'=>'asc',
'Product.productnumber'=>'asc')).  Am I making sense?  I'm missing
something obvious?

Todd

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