Editing: save_edit_lec.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.form("id_lecturer") if session("tb_edit") =2 or session("id_lecturer1")=id_lecturer then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ %> <form name="form1" method="post"> <% id_lecturer1=session("id_lecturer1") administor=request.form("administor") academic = request.form("academic") other_position = request.form("other_position") preface = request.form("preface") name_lec = request.form("name_lec") sur_lec = request.form("sur_lec") bdate_lec = request.form("bdate_lec") bmon_lec = request.form("bmon_lec") byear_lec=request.form("byear_lec") year_retire = request.form("year_retire") id_status_lec = request.form("id_status_lec") dentrance=request.form("dentrance") mentrance=request.form("mentrance") yentrance=request.form("yentrance") date_entrance=dentrance&"/"&mentrance&"/"&yentrance bd_lec=bdate_lec&"/"&bmon_lec&"/"&byear_lec 'response.write id_lecturer&"idlecturer<br>" 'response.write id_lecturer1&"idlecturer1<br>" 'id_lecturer=session("id_lecturer") sql_data="select * from lecturer where id_lecturer='"&id_lecturer&"' " 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_form.asp?id_lecturer="&id_lecturer1&"';" %> --> </SCRIPT> <% 'else sql_edit_lec = "update lecturer set id_administor='"&administor&"',id_academic='"&academic&"',id_other_position='"&other_position&"',id_preface= '"&preface&"',name_lec='"&name_lec&"',sur_lec='"&sur_lec&"',bdate_lec='"&bd_lec&"',year_retire='"&year_retire&"',id_status_lec='"&id_status_lec&"',date_entrance='"&date_entrance&"' where id_lecturer = '" & id_lecturer&"' " response.write"��䢢������������º�������Ǩ��" set ors_edit_lec=server.createobject("adodb.recordset") ors_edit_lec.open sql_edit_lec,Conn,1,3 'response.write id_lecturer&"llll" set conn = nothing ' end if %> <meta http-equiv="refresh" content ="0;url=detail_lec.asp?id_lecturer=<%=id_lecturer%>"> </FORM> <% else '���Է� response.write "<tr><td colspan=3><center>�س������Է����� �س���ѵԹ��" response.write "<meta http-equiv=refresh content =3;url=javascript:history.back();>" '���Է� end if '���Է� %>