您的位置 >>> 星想互联 >>>  >>> ASP
批量删除记录
点击数:2829  发布时间2013-05-11 10:35:42

<form id="form1" name="form1" method="post" action="view.asp"><input type="submit" name="button" id="button" value="提交" />
<%
set rs=conn.execute("select * from news order by id")
do while not rs.eof and not rs.bof
 %>
 <div><input name="myform" type="checkbox" value="<%= rs("id") %>" /><%= rs("id") %>&nbsp;&nbsp;<%= rs("title") %></div>
 <%
rs.movenext
loop
 %>
</form>

 

删除页面:

<%
set rs=conn.execute("delete from news where id in ("&request.form("myform")&")")
response.redirect "form.asp"
 %>

来源:星想互联
【上一篇】ASP中的表单数组
【下一篇】在线生成静态HTML程序