Question

如何用checkbox实现批量删除 asp技术。

发送页：
<%do while not rs.eof%>
<tr>
<td> <input type="checkbox" name="xz" value="<%=rs("sn")%>" ></td>
<td><%=rs("sn")%></td>
<td><%=rs("name")%></td>
</tr>
<%
rs.movenext
loop
%>

-----------------
接收页：
<%
exec="delete * from guestsn where sn in ('&Request.Form(xz)')"
conn.execute exec
%>
<%
Response.Write "<SCRIPT LANGUAGE='JavaScript'>"
Response.Write "alert('删除成功！');"
Response.Write "history.go(-1);"
Response.Write "</SCRIPT>"
%>
--------------------------
为什么显示已删除成功，但实际又没有删除掉。到库中还是能看到原来的东西
哪儿高手帮我解决一下这个问题哦

Answer 1

exec="delete * from guestsn where sn in ('&Request.Form(xz)')"
这个语句不对
如果你的xz是数值的话要这样写
exec="delete * from guestsn where sn in ("&Request.Form(xz)&")"

Answer 2

update,具体语法忘记了,
或者用ADO控件的方法
具体参看MSDN
看看www.w3school.com.cn

Answer 3

我觉得应该串联字符

我会用js写vb不懂
for(var e=new Enumerator(Request.Form("xz"));!e.atEnd();e.moveNext())
{
str=e.item()+",";
}
str='(’+str+')';
delete * from guestsn where sn in str