title: cakephp 2.x custom query pagination
body: <p>i have a cakephp function in my model that calls a stored procedure that returns a resultset, how do i paginate the resultset in my controller?
  here is the function in my model</p>
  
  <pre><code>public function GetSummary(){
       $sql="CALL main_report()";
       return $this-&gt;query($sql);
    }
  </code></pre>
  
  <p>and this is how am accessing the data in my controller</p>
  
  <pre><code>$usagesummary=$this-&gt;Book-&gt;GetSummary();
  </code></pre>
  
  <p>how do i paginate this data?</p>