更新附加数据而不是覆盖 [英] Update Appends Data Instead of Overwrites

问题描述

我正在使用（经典）ASP来更新数据库中的记录，当我执行更新时，它会将数据附加到现有列数据而不是替换它。 这是我更新的ASP代码：

I'm using (classic) ASP to update records in a database and when I perform the Update, it appends the data to the existing column data instead of replacing it.  Here's my ASP code for the update:

sql =" UPDATE noi_kb SET"

sql = sql &安培; "Problem_Status ='" &安培; request.form（" Problem_Status"）& "'，"

sql = sql& "分辨率="" &安培; Request.Form（"resolution"）& "'"

sql = sql& " WHERE row_id ='" &安培; row_id& "'"

Connnoikb.Execute sql

sql="UPDATE noi_kb SET "
sql=sql & "Problem_Status = '" & request.form("Problem_Status") & "',"
sql=sql & "resolution='" & Request.Form("resolution") & "' "
sql=sql & " WHERE row_id = '" & row_id & "' "
Connnoikb.Execute sql

推荐答案

它不会追加（插入）行到当你使用UPDATE代码时你的表。

It will not append(insert) row to your table when you use UPDATE code.

检查你的表以查看是否有任何更新触发器。

Check your table to see whether is has any update trigger on it.

这篇关于更新附加数据而不是覆盖的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！