how to set max limit for pagination in cakephp

Question

My code

  $this->paginate=array(
          'conditions' =>array('OrderDetail.order_id'=>$id),
            'maxLimit' => 500));

---

$this->paginate=array(
          'conditions' =>array('OrderDetail.order_id'=>$id),
            'limit' => 500));

Both result giving me 100 records max thou i set limit as 500,as if i set 500 i need 500 records.! can any body help me on this ?

Answer 1

If you think about it: You need to combine them.

public $paginate = array(
    // other keys here.
    'maxLimit' => 500,
    'limit' => 500
);

You need to first raise the maxLimit to the absolute limit you want to allow. Then you can set the limit to any value up to this point. Only setting one of them does not change anything (logically).