在作一个排课性质的程序,但是搞不定,谁帮忙看看啊?
<%
set rs2=server.createobject("adodb.recordset")
query="select * from dbo.rec where room='"&room&"'"
rs2.open query,MM_rec_STRING,1,2
if rs2.EOF AND rs2.BOF then
Call newrec()
else
Do While (NOT rs2.EOF)
if DateDiff("s",now(),overtime)<Datediff("s",now(),rs2("starttime")) AND DateDiff("s",now(),overtime)<Datediff("s",now(),rs2("overtime")) then
Call newrec()
else
%>
<script language=javascript>
history.back()
alert("录制时间有冲突!")
</script>
<%
Response.End
end if
rs2.MOVENext
LOOP
end if
%>
-----------------------------------------------------------
newrec()为添加数据的函数