Editing: add_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"--> <% session("tb_name")="lecturer"%> <!--#include file="chk_permission.asp"--> <% id_lecturer=request("id_lecturer") if session("tb_edit")=2 or session("id_lecturer1")=id_lecturer then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ %> <form name="form1" Action = "detail_lec.asp?id_lecturer=<%=id_lecturer%>" method="post"> <% 'id_lecturer=request.form("id_lecturer") finish_edu_year=request.form("finish_edu_year") id_curriculum=request.form("id_curriculum") ' ---------------------------------------------------------- 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_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") ' ----------------------------------------------------------- if finish_edu_year="" then finish_edu_year="0000" end if %> <% 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&"'" 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('"&id_lecturer&"�����ū��');" response.write "window.location.href='add_lec_edu_vita_form.asp?id_lecturer="&id_lecturer&"';" 'response.write "<meta http-equiv=refresh content =3;url=javascript:history.back();>" %> --> </SCRIPT> <% else sqlall="select * from education_vita " set orsall=server.createobject("adodb.recordset") orsall.open sqlall,conn,1,3 if orsall.eof then id_edu_vita=1 else orsall.movelast response.write orsall("id_edu_vita") id_edu_vita=orsall("id_edu_vita")+1 response.write id_edu_vita end if sqldata="insert into education_vita(id_staff,finish_edu_year,id_curriculum,id_edu_bg_t,id_edu_bg_t_sub,id_edu_bg_e,id_edu_bg_e_sub,id_major_t,id_major_e,id_campus_t,id_campus_e,country_t,country_e,id_edu_vita) values('"&id_lecturer&"','"& finish_edu_year&"','"&id_curriculum&"','"& id_edu_bg_t&"', '"&id_edu_bg_t_sub&"','"&id_edu_bg_e&"','"&id_edu_bg_e_sub&"','"&id_major_t&"', '"&id_major_e&"','"&id_campus_t&"','"&id_campus_e&"','"&country_t&"','"&country_e&"','"&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 %> </FORM> <% else '���Է� response.write "<tr><td colspan=3><center>�س������Է����� �س���ѵԹ��" response.write "<meta http-equiv=refresh content =3;url=javascript:history.back();>" '���Է� end if '���Է� %>