close_all.asp

与asp相关的技术 如数据库和网页设计 很有用的哦

<%
if session("user_type")<>"T" then
	response.redirect "../../../index.asp"
end if
%>
<% response.buffer=true%>
<!--#INCLUDE FILE="../../../system/odbc_connection.asp"-->
<%
	dim lesson_id
	lesson_id=session("lesson_id")
		sql="update homework set open_flag=0  where lesson_id='" & lesson_id & "'"
		sql=sql & " and homework_type='H'"
		db.Execute(Sql)
		db.close
		set db=nothing
		response.redirect "index.asp?lesson_id=" & lesson_id 
%>