for some reason the params array wont replace the parameters I set in the conditions -
$Criteria = new CDbCriteria();
$Criteria->select = "{$this->title}, DAYOFMONTH({$this->date}) AS {$this->date}";
$Criteria->condition = "MONTH({$this->date}) = :month AND ({$this->date}) = :year ";
$Criteria->params = array(':month' => $this->month,':year' => $this->year);
$entries = CActiveRecord::model($this->dataProvider->modelClass)->findAll($Criteria);
when I check the log I see the query -
Querying SQL: SELECT title, DAYOFMONTH(createTime) AS createTime FROM `Entry` WHERE MONTH(createTime) = :month AND (createTime) = :year
any one has any idea how to make this work ?