如果需要对数据记录进行批量删除,可借鉴使用如下方法:
将复选框的value设为表ID,递交后:
程序代码
conn.execute("delete from yourtable where id in (" & Request.Form("ID") & ")")
第二种方法就是用for....,如:
程序代码
for i=1 to request.form("id").count
conn.Execute ("Delete from yourtable where ID="&trim(Request.Form("ID")(i))&"")
next
将复选框的value设为表ID,递交后:
程序代码
conn.execute("delete from yourtable where id in (" & Request.Form("ID") & ")")
第二种方法就是用for....,如:
程序代码
for i=1 to request.form("id").count
conn.Execute ("Delete from yourtable where ID="&trim(Request.Form("ID")(i))&"")
next