Question

YII框架如何直接通过sql更新？

$sql = " update ".$val. " set TicketStatus =:TicketStatus and PauseOperator =:PauseOperator where TicketNo =:TicketNo";
$db=Yii::app()->db;
$db->createCommand($sql)->execute(array(':TicketStatus'=>'5',':PauseOperator'=>$data["PauseOperator"],':TicketNo'=>$TicketNo));

就类似于这种 更新
$db->createCommand($sql)->execute(array(':TicketStatus'=>'5',':PauseOperator'=>$data["PauseOperator"],':TicketNo'=>$TicketNo));这个不对 没有执行成功，请教！！！！！！！！

Answer 1

是你的sql语句本身有就错了，应该是这样：
$sql = " UPDATE ".$val. " SET TicketStatus =:TicketStatus , PauseOperator =:PauseOperator WHERE TicketNo =:TicketNo";

sql关键字推荐写成大写。