title: Sortable column headers without pagination?
body: <p>I'd like to be able to display all records without the actual need of pagination but still want to keep the functionality of having sortable column headers by using something like <code>$this-&gt;Paginator-&gt;sort()</code>.</p>
  
  <p>Currently I'm setting <code>'limit' =&gt; 100</code> because I know I won't ever have about more than about 50 records at a time and this works just fine, however I wanted to know if there was basically a way to accomplish the sortable columns without pagination some other way such as <code>'limit' =&gt; unlimited</code> or another Component of CakePHP that would accomplish this.</p>
  
  <p>Here's the Controller:</p>
  
  <pre><code>class GroupsController extends AppController {
  
      public function view($slug = null) {
  
          $group = $this-&gt;Group-&gt;findBySlug($slug);
  
          $this-&gt;paginate = array(
              'Person' =&gt; array(
                  'conditions' =&gt; array('Person.group_id' =&gt; $group["Group"]['id']),
                  'limit' =&gt; 100,
                  'recursive' =&gt; 0
              )
          );
  
          $people = $this-&gt;paginate('Person');
  
          $this-&gt;set('people', $people);
  
      }
  }        
  </code></pre>
  
  <p>Here's the view:</p>
  
  <pre><code>&lt;table&gt;
      &lt;tr&gt;
          &lt;th&gt;&lt;?php echo $this-&gt;Paginator-&gt;sort('Person.id','Id'); ?&gt;&lt;/th&gt;         
          &lt;th&gt;&lt;?php echo $this-&gt;Paginator-&gt;sort('first_name', 'First Name'); ?&gt;&lt;/th&gt;         
          &lt;th&gt;&lt;?php echo $this-&gt;Paginator-&gt;sort('last_name', 'Last Name'); ?&gt;&lt;/th&gt;         
      &lt;/tr&gt;
      &lt;!-- Here is where we loop through the people --&gt;
      &lt;?php foreach ($people as $person): ?&gt;
      &lt;tr&gt;
          &lt;td&gt;&lt;?php echo $person['Person']['id']; ?&gt;&lt;/td&gt;
          &lt;td&gt;&lt;?php echo $person['Person']['first_name']; ?&gt;&lt;/td&gt;
          &lt;td&gt;&lt;?php echo $person['Person']['last_name']; ?&gt;&lt;/td&gt;
      &lt;/tr&gt;
      &lt;?php endforeach; ?&gt;
      &lt;?php unset($player); ?&gt;
  &lt;/table&gt;
  </code></pre>