Zend Framework 复合主键更新

Question

对于一个项目，我需要更新 PK 包含两列的行。

起初我想我应该这样做，但它给了我错误。有人有解决办法吗？

$data = array('foo','bar');
$where = $this->_getGateway()->getAdapter()
                    ->quoteInto(array('customerId=?','date=?'), array($comment->customerId, $comment->date));
$this->_getGateway()->update($data, $where);

谢谢

Answer 1

知道了！

$whereId = $this->_getGateway()->getAdapter()->quoteInto('customerId=?', $comment->customerId);
$whereDate = $this->_getGateway()->getAdapter()->quoteInto('date=?', $comment->date);
$this->_getGateway()->update($data, array($whereId, $whereDate));