[求助]在asp中批量修改数据库表的数据
表exam_testuser中满足字段testid="&testid的字段havetest初值为空
我想把满足条件的havetest都改为0
---------------------------------------------------------------------------------------------------------
……
dim rs1,sql1
set rs1=server.createobject("adodb.recordset")
sql1="select * from exam_testuser where testid="&testid
rs1.open sql1,conn,3,2
dim i,testid1
testid1=split(request("testid"),",")
i=0
do while not (rs1.eof or rs1.bof) and i<ubound(testid1)
rs1("havetest")=0
rs1.movenext
i=i+1
rs.update
loop
rs1.close
……
---------------------------------------------------------------------------------------------------------
我的代码如上提交显示成功但 数据库中havetest并没有被修改为0
请高手帮忙!!谢谢!