insert into ...select 在for循环
<%
subject=split(trim(request("subject")),",")
singecount=split(request("singlecount"),",")
multicount=split(request("multicount"),",")
judgecount=split(request("judgecount"),",")
a=ubound(subject)
for b=0 to a
subjectid=subject(b)
singecountid=singecount(b)
randomize
sqlsinge="insert into exam_databasebak SELECT TOP "
sqlsinge=sqlsinge+singecountid
sqlsinge=sqlsinge+" * FROM exam_database WHERE subject='"
sqlsinge=sqlsinge+subjectid
sqlsinge=sqlsinge+"' and type='单选题' ORDER BY Rnd(id)"
set rs1=conn.execute(sqlsinge)
set rs1=nothing
Session("subjectid")= subjectid
Next
%>
在这个循环中RS1只执行了一次,为什么?请大侠帮帮