Editing: save_edit_lec_edu_vita.asp.bak

<!--#INCLUDE FILE="Connectdb.asp"--> <!--#include file="inc_cache_control.asp"--> <!--#include file="inc_access_control.asp"--> <!--#include file="chk_login.asp"--> <% id_edu_vita=request("id_edu_vita") '***************************************************************** %> <!--#include file="chk_permission.asp"--> <% '***************************************************************** 'response.write id_staff id_lecturer=request("id_lecturer") 'response.write id_s 'response.write session("id_lecturer1") session("tb_name")="lecturer" if session("tb_edit") =2 or session("id_lecturer1") = id_lecturer then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ response.write id_s %> <% finish_edu_year=request.form("finish_edu_year") id_edu_bg_t=request.form("id_edu_bg_t") id_edu_bg_e=request.form("id_edu_bg_e") id_edu_bg_t_sub=request.form("id_edu_bg_t_sub") id_edu_bg_e_sub=request.form("id_edu_bg_e_sub") id_major_t=request.form("id_major_t") id_major_e=request.form("id_major_e") id_curriculum=request.form("id_curriculum") id_campus_t=request.form("id_campus_t") id_campus_e=request.form("id_campus_e") country_t=request.form("country_t") country_e=request.form("country_e") response.write "aaa"&id_lecturer&"sss"&id_edu_vita&"vvv" %> <form name="form1" Action = "detail_lec.asp" method="post"> <% 'sql_data="select * from education_vita where id_staff='"&id_lecturer&"' and id_curriculum='"&id_curriculum&"' and 'id_edu_bg_t='"&id_edu_bg_t&"' and id_major_t='"&id_major_t&"'and finish_edu_year='"&finish_edu_year&"'" ' 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_lec_edu_vita_form.asp?id_edu_vita="&id_edu_vita&"&id_lecturer="&id_lecturer&"';" %> --> <%'</SCRIPT> '�礤�ҫ��else sqldata="update education_vita set id_staff='"&id_lecturer&"',id_edu_bg_t='"&id_edu_bg_t&"',id_edu_bg_t_sub='"&id_edu_bg_t_sub&"',id_edu_bg_e='"&id_edu_bg_e&"',id_edu_bg_e_sub='"&id_edu_bg_e_sub&"' ,id_major_t='"&id_major_t&"',id_major_e='"&id_major_e&"',id_curriculum='"&id_curriculum&"',id_campus_t='"&id_campus_t&"',id_campus_e='"&id_campus_e&"',country_t='"&country_t&"',country_e='"&country_e&"' ,finish_edu_year='"&finish_edu_year&"' where id_edu_vita='"&id_edu_vita&"'" set orsdata = Server.CreateObject("adodb.recordset") orsdata.open sqldata,conn,1,3 response.write sqldata response.write "<meta http-equiv='refresh' content ='0;url=edu_lec.asp?id_lecturer="&id_lecturer&"'>" '�礤�ҫ��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 '���Է� %>