Editing: add_stugroup.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")="student" %> <!--#include file="chk_permission.asp"--> <% '***************************************************************** if session("tb_edit") <> 1 then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ %> <form name="form1" Action = "detail_stugroup.asp" method="post"> <% 'id_stugroup=request.form("id_stugroup") no_stugroup=request.form("no_stugroup") id_begin_year=request.form("id_begin_year") id_begin_semeter = request.form("id_begin_semeter") id_curriculum=request.form("id_curriculum") id_type_curri = request.form("id_type_curri") id_end_year = request.form("id_end_year") id_end_semeter = request.form("id_end_semeter") id_edu_bg = request.form("id_edu_bg") id_major = request.form("id_major") year_edu=request.form("year_edu") ' bmon_lec=request.form("bmon_lec") 'byear_lec=request.form("byear_lec") ' bd_lec=bdate_lec&"/"&bmon_lec&"/"&byear_lec id_begin_y=right(id_begin_year,2) id_stugroup=no_stugroup+id_begin_y+id_begin_semeter+id_curriculum+id_type_curri response.write id_stugroup %> <% sql_data="select * from student_group where 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('"&id_stugroup&"�ѹ�֡���ʻ�Шӵ�ǫ��');" response.write "window.location.href='add_group_form.asp';" %> --> </SCRIPT> <% else sqldata="insert into student_group(id_stugroup,no_stugroup,id_begin_year,id_begin_semeter,id_curriculum,id_type_curri, id_end_year,id_end_semeter,id_edu_bg,id_major,year_edu) values('"&id_stugroup&"','"&_ no_stugroup&"','"&id_begin_year&"','"&_ id_begin_semeter&"', '"&id_curriculum&"','"&id_type_curri&"','"&id_end_year&"','"&id_end_semeter&"','"&id_edu_bg&"','"&id_major&"','"&year_edu&"')" set orsdata = Server.CreateObject("adodb.recordset") orsdata.open sqldata,conn,1,3 response.write sqldata response.write "<meta http-equiv='refresh' content ='0;url=detail_stugroup.asp?id_stugroup="&id_stugroup&"'>" end if ''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 '���Է� %>