怎样删除多个单选选项
//循环语句
<input type=checkbox name=list value="<%=rs("id")%>">删除</td>
//循环语句
For p = 1 To i
sql="delete * from dhd where id="&int(request.querystring("list"))&" "
conn.execute sql
conn.close
Next
请问怎么改？
问题点数：30、回复次数：2Top
1 楼baggio785（狗狗）回复于 2002-05-03 15:25:26 得分 15
num=Request.Form ("list").Count
for i=1 to num
id=CLng(Request.Form ("list")(i))
if id<>"" then
sql="delete * from dhd where id="&int(request.querystring("list"))&" "
conn.execute(sql)
end if
nextTop
2 楼tripofdream（梦之旅）回复于 2002-05-04 02:36:46 得分 15
不需要循环,使用in子句.
sql="delete * from dhd where id in (" &request.querystring("list") & ")"
conn.execute sql
conn.close
Top
