Question

asp修改语句 的问题

下下面的代码是添加的语句,我每次点修改后他就添加了一条新记录,如何把它改为修改,请高人帮忙.

<form name="form1" method="post" action="?action=save" onSubmit="return Validator.Validate(this,2)">
<input name="id" type="hidden" id="id" value="<%= rs("id") %>"> <input name="sort" type="text" class="form2" id="sort" value="<%=rs("sort")%>" dataType="Require" msg="请填写产品类别名称！">
<input name="sx" type="text" class="form2" id="sx" value="<%=rs("sx")%>" size="15" dataType="Number" msg="请填写产品类别排列序号(必须为数字)！">
<input type="submit" name="Submit" value=" 修 改 ">

----------------------------------------------------------------

if request.querystring("action")="save" then
if trim(request.form("sort"))="" then
response.Write "<script language=javascript>alert('请填写产品类别！');window.location.href='big_sort.asp';</script>"
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="select * from product_sort"
rs.open sql,conn,1,3
rs.addnew
rs("sort")=server.HTMLEncode(trim(request.form("sort")))
rs("sx")=server.HTMLEncode(trim(request.form("sx")))
rs.update
response.Write "<script language=javascript>alert('添加产品大类成功！');window.location.href='big_sort.asp';</script>"
rs.close
set rs=nothing
conn.close
set conn=nothing
end if

Answer 1

只需要修改这三行即可！
sql="select * from product_sort"
rs.open sql,conn,1,3
rs.addnew
将上面改为：
id=request.form("id")
sql="select * from product_sort id='"&id&"'"
rs.open sql,conn,1,3

Answer 2

rs.addnew 去掉

然后在sql="select * from product_sort" 中加入条件限制：
如sql="select * from product_sort where product_ID=15" （修改第15条记录）

Answer 3

if request.querystring("action")="save" then
if trim(request.form("sort"))="" then
response.Write "<script language=javascript>alert('请填写产品类别！');window.location.href='big_sort.asp';</script>"
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="select * from product_sort"
rs.open sql,conn,1,3
rs.addnew
rs("sort")=server.HTMLEncode(trim(request.form("sort")))
rs("sx")=server.HTMLEncode(trim(request.form("sx")))
rs.update
response.Write "<script language=javascript>alert('添加产品大类成功！');window.location.href='big_sort.asp';</script>"
rs.close
set rs=nothing
conn.close
set conn=nothing
end if

改为
if request.querystring("action")="save" then
if trim(request.form("sort"))="" then
response.Write "<script language=javascript>alert('请填写产品类别！');window.location.href='big_sort.asp';</script>"
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="select * from product_sort where id='"&request("id")&"'"
rs.open sql,conn,1,3
rs("sort")=server.HTMLEncode(trim(request.form("sort")))
rs("sx")=server.HTMLEncode(trim(request.form("sx")))
rs.update
response.Write "<script language=javascript>alert('修改产品大类成功！');window.location.href='big_sort.asp';</script>"
rs.close
set rs=nothing
conn.close
set conn=nothing
end if