ASP+SQL 让所有ID相符的 “tpqk"字段值全部为 1
<%
ipso=trim(request.QueryString("ipso"))
page=trim(request.QueryString("page"))
                set rs=server.createobject("adodb.recordset")
                sql="Select * from ipdata where id in ("&request.form("selectdel")&")"
                rs.open sql,conn,1,1
                do while not rs.EOF
                  rs("tpqk")="1"
                rs.update
                rs.movenext
                loop
                rs.close
                set rs=nothing
                Response.Redirect "tplist.asp?ipso="&ipso&"&page="&page&""

%>

sql="Select * from ipdata where id in ("&request.form("selectdel")&")"
response.write sql
response.end
看看你的SQL语句。

我找了一下，直接用了

这个没反映conn.execute("update ipdata set tpqk=1 where id in("&request.form("id")&")")
conn.execute("update ipdata set tpqk=1 where id=** ")
这个正常