title: How to remove limit condition using CDbCriteria in Yii 1.1.14
body: <p>I want to show full list of data from database using CDbCriteria and CActiveDataProvider.
  I make like :</p>
  
  <pre><code>$criteria=new CDbCriteria;
  $criteria-&gt;alias = 'C';
  if ( !$enablePagination ) {
    $criteria-&gt;limit= 0;
    $criteria-&gt;offset= 0;
  }
  </code></pre>
  
  <p>debugging CDbCriteria object I see :</p>
  
  <pre><code>$criteria::CDbCriteria Object
  (
      [select] =&gt; *
      [distinct] =&gt; 
      [condition] =&gt; 
      [params] =&gt; Array
          (
          )
  
      [limit] =&gt; 0
      [offset] =&gt; 0
      [order] =&gt; name asc
      [group] =&gt; 
      [join] =&gt; 
      [having] =&gt; 
      [with] =&gt; 
      [alias] =&gt; C
      [together] =&gt; 
      [index] =&gt; 
      [scopes] =&gt; 
      [_e:CComponent:private] =&gt; 
      [_m:CComponent:private] =&gt; 
  )
  </code></pre>
  
  <p>But tracing my sql I see anyway :</p>
  
  <pre><code> SELECT *  FROM `tbl_category` `C` ORDER BY name asc LIMIT 10 
  </code></pre>
  
  <p>How to remove limit condition ?</p>
  
  <p>Yii 1.1.14.</p>
  
  <p>Thanks!</p>