How to update only specific fields of an active record in Yii?

Question

I have a model (ActiveRecord) that has 5 properties (DB columns).
I fetch a specific record and populate a form that has 3 fields (two other fields shouldn't be updated).
Then I change a specific field and press save.

How to update the record, not touching the fields that are not in form?

Answer 1

The approach pointed out by mazzucci is more complicated than necessary. Try this:

YourTable::model()->updateByPk($id, array(
    'field1' => NewVal1,
    'field2' => NewVal2,
    'field3' => NewVal3
));