ActiveRecord and decrementing values

Yii 1.1 General Discussion
1

Hi,

How can I do something like this using ActiveRecord:




UPDATE pages SET Position = Position - 1 WHERE Position > :position AND AND ParentID = :parentID

I’m trying to do:




PageRecord::model()->updateAll(array('Position' => '(Position - 1)'), 'Position > :position AND ParentID = :parentID', array(':position' => $position, ':parentID' => $parentID));

But this doesn’t seem to work.

2

You need a updateCounters()




PageRecord::model()->updateCounters(array('Position' => -1), 'Position > :position AND ParentID = :parentID', array(':position' => $position, ':parentID' => $parentID));