这个就是传说中的批量更新

exec="select * from products where gameid="&cint(progameid)

set rs=server.createobject("adodb.recordset")

rs.open exec,conn,3,3

'++++++++++++++++++++++++++++++++++++++++++++++++++++

do while not rs.eof

rs("content") = procontent 'this is centent

rs.update

rs.movenext

loop

rs.close

set rs=Nothing

asp批量更新记录

ClassType="姓名"

sql="select * from TableName where ClassType='"&ClassType&"'"

rs.open sql,conn,1,3

Do While Not rs.eof

rs("FiledName")=xxxx

rs.movenext

Loop

rs.BatchUpdate<————–批量更新