更新的数据表是同一个
<!--#include file="conn.asp"-->
<%
ID=request("ID")
for i=1 to request.form("ID").count
set rs_s=server.CreateObject("adodb.recordset")
conn.execute("update ABB set num2='"&num2&"',num1='"&num1&"+"&num2&"' where ID="&request.form("ID")(i))
next
response.Redirect "rsearch1.asp?"
%>
结果回复的是“没有搜索条件”,而且重新查询的结果是num1列的数据为num1++++,修改几次就有几个加号,而且是一整列都同时记录
就是你帮我改的那一段阿
'ID=request("id")
for i=1 to request.form("ID").count
'if request.form("ID")(i)<=0 then
'ID=1
'else
'ID=request.form("ID")(i)
'end if
set rs_s=server.CreateObject("adodb.recordset")
rs_s.open "select * from ABB where ID="&request.form("ID")(i),conn,1,1
gh=rs_s("gh")
num2=rs_s("num1")
temp=request.form("num2")(i)
num1=temp+num2
rs_s.close
set rs_s=nothing
'response.write gh&" "&num2
'response.end
conn.execute("update ABB set num2="&num2&",num1="&num1&" where ID="&request.form("ID")(i))
next
response.Redirect "rsearch1.asp"