Editing: save_edit_advisor.asp.bak

<!--#INCLUDE FILE="Connectdb.asp"--> <!--#include file="inc_cache_control.asp"--> <!--#include file="inc_access_control.asp"--> <!--#include file="chk_login.asp"--> <% '***************************************************************** session("tb_name")="lecturer" %> <!--#include file="chk_permission.asp"--> <% '***************************************************************** if session("tb_edit") =2 then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ %> <form name="form1" Action = "detail_advisor.asp" method="post"> <% id_lecturer=request.form("id_lecturer") id_year=request.form("id_year") id_stugroup=session("id_stugroup") %> <% sql_data="select * from advisor_student where id_lecturer='"&id_lecturer&"'and id_stugroup='"&id_stugroup&"' " set ors_data=server.createobject("adodb.recordset") ors_data.open sql_data,conn,1,3 if not ors_data.eof then%> <SCRIPT LANGUAGE="JavaScript"> <% 'response.write "���ʫ��"&id_lecturer response.write"alert('�ѹ�֡�����ū��');" response.write "window.location.href='edit_advisor_form.asp?id_stugroup="&id_stugroup&"&id_lecturer="&id_lecturer&"&id_year="&id_year&"';" %> --> </SCRIPT> <% else sqldata="update advisor_student set id_lecturer='"&id_lecturer&"',id_year='"&id_year&"' where id_stugroup='"&id_stugroup&"'" set orsdata = Server.CreateObject("adodb.recordset") orsdata.open sqldata,conn,1,3 response.write sqldata response.write "<meta http-equiv='refresh' content ='5;url=detail_advisor.asp?id_lecturer="&id_lecturer&"&id_stugroup="&id_stugroup&"'>" end if set conn = nothing 'ors_data.close %> </FORM> <% else '���Է� response.write "<tr><td colspan=3><center>�س������Է����� �س���ѵԹ��" response.write "<meta http-equiv=refresh content =3;url=javascript:history.back();>" '���Է� end if '���Է� %>