How To Use Active Records Update Method

I would like to try active record and its update feature.

Here’s my query:

UPDATE bau, test

SET basisname = test.text

WHERE bau.process_1_ID = test.p_1_ID

AND bau.process_2_ID = test.p_2_ID

AND bau.process_3_ID = test.p_3_ID

AND bau.ee_ID = 0;

Please someone tell me how to put condition and other parametres

Hi RuliTheHat

YourClass::model()->updateByPk($pk,$attributes,$condition,$params);

where condition

$criteria=new CDbCriteria;

$criteria->addCondition(‘field1=:value1’);

$criteria->params=array(’:value1’=>10);

…

…

etc