Question

asp批量更新数据库

set rsd=server.CreateObject("adodb.recordset")
rsd.open "Select * from Debate where Debate_id="&Debate_id&" order by intotime desc",conn,1,3
id=rsd("id")
conn.execute("update Debate set hits=hits+1 where id=" & id)
以上更新只能更新数据库中的一条信息,但符合Debate_id="&Debate_id&" 的记录是多条的,本人现想将这些多条记录hits字段全部更新为hits=1, 在下在此请教高手该如何操作?谢谢了!

Answer 1

conn.execute("宴悄update Debate set hits=hits+1 where id in (Select id from Debate where Debate_id="&Debate_id&")")

直接运行这个渣祥磨就行了，上面的也不如斗用了

Answer 2

update Debate set hits=hits+1