怎么才能删除多条记录？
在给大家提议个问题就是管理员怎样才能把选中的数据都删除呢？我定义了checkbox，然后选中一个可以删除的掉，但是选中多个就删除不了？
这种情况语句该怎么定义啊？
谢谢！
<script language="javascript">
function CheckAll(form){
for (var i=0;i<form.elements.length;i++){
var e = form.elements[i];
if (e.name != 'chkall') e.checked = form.chkall.checked;
}
}
</script>
<%
if request.form("action")="批量删除" then
delid=request.form("delid")
if delid<>"" and not isnull(delid) then
conn.execute "delete from UserMain where id in ("&delid&")"
end if
%>
<form action="" method="post">
<%
set rs=server.createobject("adodb.recordset")
rs.open "select * from UserMain order by id desc",conn,1,1
do while not rs.eof
%>
<input type="checkbox" name="delid" value="<%=rs("id")%>" />
<%
rs.movenext
loop
rs.close
set rs=nothing
%><br />
<input type="checkbox" name="chkall" onclick="CheckAll(this.form);" />
<input type="submit" name="action" value="批量删除" />
</form>
function CheckAll(form){
for (var i=0;i<form.elements.length;i++){
var e = form.elements[i];
if (e.name != 'chkall') e.checked = form.chkall.checked;
}
}
</script>
<%
if request.form("action")="批量删除" then
delid=request.form("delid")
if delid<>"" and not isnull(delid) then
conn.execute "delete from UserMain where id in ("&delid&")"
end if
%>
<form action="" method="post">
<%
set rs=server.createobject("adodb.recordset")
rs.open "select * from UserMain order by id desc",conn,1,1
do while not rs.eof
%>
<input type="checkbox" name="delid" value="<%=rs("id")%>" />
<%
rs.movenext
loop
rs.close
set rs=nothing
%><br />
<input type="checkbox" name="chkall" onclick="CheckAll(this.form);" />
<input type="submit" name="action" value="批量删除" />
</form>
[此贴子已经被作者于2007-11-5 17:31:25编辑过]
