Question

ASP批量修改数据库中某一个字段的值

<!--#include file="conn.asp"-->
<%
non=Trim(Request.Form("non"))
sql="select * from kehu where id in ("&Request.Form("checkbox")&")"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
rs("gonghao")=non
rs.update
rs.close
set rs=nothing
response.write "<script>alert('操作成功');this.location.href='javascript:history.go(-1)';</script>"
%>

这段代码只能修改一条数据，我的复选框是这样的
<input type="checkbox" name="checkbox" value="<%=rs("id")%>">
循环显示的数据，我确定已经选择的多条数据，但是只能修改到一条，没有报任何错误。

Answer 1

<!--#include file="conn.asp"-->
<%
non=Trim(Request.Form("non"))
sql="select * from kehu where id in ("&Request.Form("checkbox")&")"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
do while not rs.eof
rs("gonghao")=non
rs.update
rs.movenext
loop
rs.close
set rs=nothing
response.write "<script>alert('操作成功');this.location.href='javascript:history.go(-1)';</script>"
%>

Answer 2

改成下面的语句试试看吧
<!--#include file="conn.asp"-->
<%
non=Trim(Request.Form("non"))
sql="update kehu set gonghao='"&non&"'"
sql=sql&" where id in ("&Request.Form("checkbox")&")"
conn.execute(sql)
response.write "<script>alert('操作成功');this.location.href='javascript:history.go(-1)';</script>"
%>