28,391
社区成员
发帖
与我相关
我的任务
分享
sql="select * from [biao] order by ID asc"
Set tmpRs=Server.CreateObject("adodb.recordset")
tmpRs.open sql,Conn,1,3
Do While Not tmpRs.eof
tmpRs("myname")="名字"
tmpRs("mynum")=100
'tmpRs.update
tmpRs.movenext
Loop
'tmpRs.update
tmpRs.close
Set tmpRs=nothing
Conn.Execute("Update [biao] Set [myname]='名字',[munum]=100")
sql="select * from [biao] order by ID asc"
Set tmpRs=Server.CreateObject("adodb.recordset")
tmpRs.open sql,Conn,1,3
Do While Not tmpRs.eof
Conn.Execute("Update [biao] Set [myname]='名字',[munum]=100 Where [ID]="tmoRs("ID"))
tmpRs.movenext
Loop
'tmpRs.update
tmpRs.close
Set tmpRs=nothing