我的意思是if not rsfinds.eof then ‘此后面没有要执行的语句
else
执行语句
endif
既然这样就不要else,直接if not rsfinds.eof then
执行语句
endif
摘自书中:
set rsfinds=conn.execute("select * from report where 试卷id="&testid&" and 学生id="&session("id")&" and (是否补考=True and 补考成绩=0)")
if not rsfinds.eof then
else
sqlin="insert into report (id,试卷id,学生id,分数) values("&qi&","&testid&","&session("id")&",0)"
set rsin=conn.execute(sqlin)
end if
set rsfinds=conn.execute("select * from report where 试卷id="&testid&" and 学生id="&session("id")&" and (是否补考=True and 补考成绩=0)") if rsfinds.eof then sqlin="insert into report (id,试卷id,学生id,分数) values("&qi&","&testid&","&session("id")&",0)" set rsin=conn.execute(sqlin) end if