I am just wondering why after I call getText(). I cannot set query limit anymore.
$query = Yii::app()->db->createCommand();
....
....
....
$sql = $query->getText();
$count = count($this -> findAllBySql ($sql));
$query->limit(10, 0);
$sql = $query->getText();
Thanks