File Manager

<%
		  pern=session("username")
		  per="2"
		  tb="lecturer"
		  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
		  %>
<%
id_aw=request.form("id_aw")
id_staff=request.form("id_staff")
month_aw=request.form("month_aw")
year_aw=request.form("year_aw")
id_typeaw=request.form("id_typeaw")
name_aw=request.form("name_aw")
title_aw=request.form("title_aw")
statusletter="1"

dcreate=now
usercreate=session("username")
sqldata="update academic_work set month_aw="&month_aw&" ,year_aw="&year_aw&",type_aw="&id_typeaw&",name_aw='"&name_aw&"',title_aw='"&title_aw&"',dateedit='"&dcreate&"',useredit='"&usercreate&"',id_staff='"&id_staff&"' where id_aw="&id_aw&""
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=detail_aw.asp?id="&id_aw&"'>"

'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: save_edit_aw.asp.bak