function UpdateField($arFields, $RESULT_ID, $FIELD_ID)
{
$err_mess = (CFormResult::err_mess())."<br>Function: UpdateField<br>Line: ";
global $DB, $strError;
$RESULT_ID = intval($RESULT_ID);
$FIELD_ID = intval($FIELD_ID);
$strUpdate = $DB->PrepareUpdate("b_form_result_answer", $arFields, "form");
$strSql = "UPDATE b_form_result_answer SET ".$strUpdate." WHERE RESULT_ID=".$RESULT_ID." and FIELD_ID=".$FIELD_ID;
$DB->Query($strSql, false, $err_mess.__LINE__);
}
function UpdateField($arFields, $RESULT_ID, $FIELD_ID)
{
$err_mess = CFormResult::err_mess() . "<br>Function: UpdateField<br>Line: ";
global $DB, $strError;
$arBinds = array();
$RESULT_ID = intval($RESULT_ID);
$FIELD_ID = intval($FIELD_ID);
$DB->StartTransaction();
$strSql = "SELECT ID FROM b_form_result_answer WHERE RESULT_ID=" . $RESULT_ID . " and FIELD_ID=" . $FIELD_ID . " FOR UPDATE ";
$z = $DB->Query($strSql, false, $err_mess . __LINE__);
while ($zr = $z->Fetch()) {
$strUpdate = $DB->PrepareUpdate("b_form_result_answer", $arFields, "form");
$strSql = "UPDATE b_form_result_answer SET " . $strUpdate . " WHERE ID=" . $zr["ID"];
if (is_set($arFields, "ANSWER_TEXT_SEARCH")) {
$arBinds["ANSWER_TEXT_SEARCH"] = $arFields["ANSWER_TEXT_SEARCH"];
}
if (is_set($arFields, "ANSWER_VALUE_SEARCH")) {
$arBinds["ANSWER_VALUE_SEARCH"] = $arFields["ANSWER_VALUE_SEARCH"];
}
if (is_set($arFields, "USER_TEXT_SEARCH")) {
$arBinds["USER_TEXT_SEARCH"] = $arFields["USER_TEXT_SEARCH"];
}
if (is_set($arFields, "USER_TEXT")) {
$arBinds["USER_TEXT"] = $arFields["USER_TEXT"];
}
$DB->QueryBind($strSql, $arBinds);
}
$DB->Commit();
}
