Zend Framework $db->update() Simple math

[GregL83]

Hey,

 

I'm trying to run a update using the db adapter object in zend framwork.  I want to have simple math in the sql statement using the update function.  Is this possible?

 

i.e.

 

$data = array(
   'number' => 'number + 1'
);
$where = array(
   'id = ?' => 1
);
$db->update('sampleTable', $data, $where);

 

Thanks in advance!

[GregL83]

That didn't take me long... 

 

$data = array(   'number' => new Zend_Db_Expr('number + 1')   );

 

http://framework.zend.com/manual/en/zend.db.adapter.html#zend.db.adapter.write.insert