请教如何在asp实现记录的多选，并批量提交????

[wyhgg]

请教如何在asp实现记录的多选，并批量提交????
请给出例了，谢谢先

[fhsoft8508539]

我也想知道，请那为大哥告诉我们

[pzwdyc]

<%@ Language=VBScript %>
<%
strpage = Request.Form("page")
'记录要删除的记录数目
count = request.form("id").count
sql1 = "DELETE FROM problems WHERE id = "
‘建立数据库连接，做一循环。依次删除每条记录
set conn = server.CreateObject("adodb.connection")
conn.Open Application("dsn")
for i = 1 to count
conn.Execute sql1 & request.form("id")(i)
'Response.Write sql1 & request.form("id")(i)
next

conn.close
set conn = nothing

response.redirect "problemadmin.asp?page="&strpage
%>

[qiao198]

分太少了，我告诉你吧，用Split

[jiangjiewebsky]

批理提交用数组实现

for ....
rs.addnew
rs(..)=data(i,j)
rs.update

next

[mustapha]

aaa=Split(Request("checkbox"),",")
for i= 0 to ubound(aaa)
if i=0 then
dh="'" & aaa(0) & "'"
else
dh =dh & "," & "'" & trim(aaa(i)) & "'"
end if
sql="delete from table where dh in(" & dh & ")"
conn.execute sql
这是个批量删除的例子