asp数据库更新语句
请大家帮忙看看这段语句错在哪里,为什么一直调试不出来,谢谢啦~~~其中checked_job是返回数字2,each_id是返回之前页面复选框对对应的数据库id号码
Dim checked_job
checked_job = request.Form("checked")
response.Write checked_job
Dim each_id,sql,rs
For I=1 to request.Form("id").count
each_id = request.Form("id")(I)
set rs=server.CreateObject("adodb.recordset")
Sql="update materiel_list set checked = '"& checked_job &"' where id = "& each_id
rs.Open sql,db,1,2
Next