File Manager

<%
		  pern=session("username")
		  per="2"
		  tb="student"
		  sqlnc="select * from tb_permission where id_staff='"&pern&"' and tb_edit='"&per&"' and tb_name='"&tb&"'"
		  set orsnc=server.createobject("adodb.recordset")
		  orsnc.open sqlnc,conn,1,3
				if not orsnc.eof then
		  %>
<%
idt=request.form("idt")
id_stuc=request.form("id_stuc")
id_thesisc=request.form("id_thesisc")
date1=request.form("date1")
date2=request.form("date2")
month1=request.form("month1")
month2=request.form("month2")
year1=request.form("year1")
year2=request.form("year2")
room=request.form("room")
time1=request.form("time1")
id_result=request.form("id_result")

dtestreal=year2&""&month2&""&date2
dtest=year1&""&month1&""&date1
		  
dcreate=now
usercreate=session("username")
sqldata="update thesis_test set date1='"&date1&"',date2='"&date2&"',month1='"&month1&"',month2='"&month2&"',year1='"&year1&"',year2='"&year2&"',id_room='"&room&"',id_time='"&time1&"',dedit='"&dcreate&"',staffedit='"&usercreate&"',dtest='"&dtest&"', dtestreal='"&dtestreal&"',id_result='"&id_result&"' where id="&idt&""
set orsdata=server.createobject("adodb.recordset")
orsdata.open sqldata,conn,1,3
response.write sqldata
%>
<SCRIPT LANGUAGE="JavaScript">
<%
response.write "alert('�ѹ�֡���������º����');"
%>
		
		</SCRIPT>
		<%
		response.write "<meta http-equiv='refresh' content ='0;url=reserve_room_test_form.asp?id_thesis="&id_thesisc&"&id_stu="&id_stuc&"'>"

'else
%>
<SCRIPT LANGUAGE="JavaScript">
<%

'response.write"alert('�ѹ�֡�����ū��++ ��ҹ��ѹ�֡�����Ź�������');"
		'response.write "window.location.href='indexletterin.asp';"
%>
		-->
		</SCRIPT>
		<%
'response.write "�����ū�� "
'response.write "<meta http-equiv='refresh' content ='7;url=index.asp'>"
'end if

%><%
else
%>
<SCRIPT LANGUAGE="JavaScript">
<%

response.write "window.location.href='index.html';"
		%>
		-->
		</SCRIPT>
		<%
end if

File Manager

Editing: reserve_room_save.asp.bak