How Exclude Column In Activerecord By Default

so, how can i exclude particular column by default in select queries and then include on request? The reason is i would like to store BLOB in column, for example.

you can do it in findAll() like this example:

$model = Model::model()->findAll(array(

        	'select'=>'id, column1, column2, column5',


oh, thanks man

i forgot really about CDbCriteria

thanks again for pointing

No differences follow this:

$criteria = new CDbCriteria();

$criteria->select='id, column1, column2, column5';

$dataProvider = new CActiveDataProvider('Model',array(

    	'criteria' => $criteria,


For select.