title: Why is CakePHP 1.3 Pagination ignoring my order?
body: <p>I have a reports model, and I for the life of me cannot get it to change the order because of the use of the $this->paginate() in displaying the data. What am I doing wrong? It's as if the $paginate variable I set up has no impact whatsoever on the next line where $this->paginate() is called.</p>
  
  <pre><code>$this-&gt;Report-&gt;recursive = 0;
  $paginate = array('order' =&gt; array('Report.id' =&gt; 'DESC'));
  $this-&gt;set('reports', $this-&gt;paginate());
  </code></pre>
  
  <p>UPDATE:</p>
  
  <p>I have tried a few more things, with no success at all.</p>
  
  <ol>
  <li>I tried declaring the $paginate variable outside of the Report controller's index. This caused the page to not load</li>
  <li>$paginate = array('order' => array('Report.id' => 'asc'),'limit' => 5);</li>
  <li>$paginate = array('Report' => array('order' => array('Report.id' => 'asc'),'limit' => 5));</li>
  <li>$paginate = array('order' => array('Report.id ASC'),'limit' => 5);</li>
  <li>$paginate = array('order' => array('id' => 'asc'),'limit' => 5);</li>
  </ol>
  
  <p>Neither the order, or the limit have any effect on the output of $this->paginate();</p>