I have the following code that creates a CDbCommand in Yii:
$cmd = Yii::app()->db->createCommand(array(
'select'=>'CMUM, CPRO, CUN, DMUN50',
'from'=>'PROVINCIAS',
'where'=>'CPRO = :CPRO'
));
$cmd->bindParam(":CPRO", $CPRO, PDO::PARAM_STR);
$cmd->setLimit(2);
This should limit the query result to 2 rows, but I get all available rows. Why?
Regards