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

id_comment=request.form("id_comment")
comments=request.form("comments")

datetimeedit=now

sqldata="update student_comment set comment='"&comments&"' ,datetimeedit='"&datetimeedit&"' where id_comment="&id_comment&""
set orsdata=server.createobject("adodb.recordset")
response.write sqldata
orsdata.open sqldata,conn,1,3

%>
<SCRIPT LANGUAGE="JavaScript">
<%
response.write "alert('�ѹ�֡���������º����');"
%>
		
		</SCRIPT>
		<%
		sqls="select * from student_comment where id_comment='"&id_comment&"'"
		set orss=server.createobject("adodb.recordset")
		orss.open sqls,conn,1,3
		if not orss.eof then
		id_stu=orss("id_student")
		end if
		response.write "<meta http-equiv='refresh' content ='0;url=add_comment_stu_form.asp?id="&id_stu&"'>"

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