我正在将Zend_Db与 Oracle 适配器一起使用,并且我正在尝试在 WHERE
子句中使用 IN()
语句执行查询。
该语句不会生成任何错误,但也不会执行更新。我尝试了以下形式:
$arrLinesCanceled = array('0000000001', '0000000002');
// attempt 1
$db->query(
"UPDATE my_table SET STATUS = :status WHERE id IN(:lineIds)",
array(
'lineIds' => $arrLinesCanceled,
'status' => 'C',
))->execute();
// attempt 2 (this actually errors out with 'not all parameters are bound')
$db->query(
"UPDATE my_table SET STATUS = :status WHERE id IN(:lineIds)"
)->execute(array(
'lineIds' => $arrLinesCanceled,
'status' => 'C',
));
// attempt 3
$stmtUpdateDetailStatus = $db->prepare(
"UPDATE my_table SET STATUS = :status WHERE id IN(:lineIds)");
$stmtUpdateDetailStatus->execute(array(
'lineIds' => $arrLinesCanceled,
'status' => 'C',
));
// last, very desperate attempt
$db->query("UPDATE my_table SET STATUS = :status WHERE id IN(:lineIds)", array(
':lineIds' => $arrLinesCanceled,
':status' => 'C',
))->execute(array(
':lineIds' => $arrLinesCanceled,
':status' => 'C',
));
为了确保输入正确,这是$arrLinesCanceled
的实际print_r
Array( [0] => 6617 [1] => 6618)
Oracle 11 或 Zend_Db 适配器不支持此功能吗?我看不出可能出了什么问题...
关于文档,在 SQL 语法中使用命名占位符(那些 :placeholder
)时,您还需要在参数数组中使用确切的占位符名称 - 这意味着,也使用冒号:
:
$db->query(
"UPDATE MOVE_LIST_EMPLOYEE_DETAILS SET STATUS = :status
WHERE MOVE_LIST_DETAIL_ID IN(:lineIds)"
)->execute(array(
':lineIds' => $arrLinesCanceled,
':status' => 'C',
));