Editing: add_course_schedule.asp.bak

<!--#include file="inc_cache_control.asp"--> <!--#include file="inc_access_control.asp"--> <!--#include file="chk_login.asp"--> <% '***************************************************************** session("tb_name")="course" %> <!--#include file="chk_permission.asp"--> <% '***************************************************************** if session("tb_edit") <> 1 then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ %> <% id_date=request.form("id_date") id_course_eng=session("id_course_eng") id_schedule=session("id_schedule") sec_tion=request.form("sec_tion") time_learn = request.form("time_learn") room_learn=request.form("room_learn") room_test=request.form("room_test") stu_learn=request.form("stu_learn") %> <% sql_data="select * from course_schedule3 where id_course_eng='"&id_course_eng&"' and id_schedule='"&id_schedule&"'" 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='detail_course_schedule.asp?id_course_eng="&id_course_eng&"&id_schedule="&id_schedule&"';" %> --> </SCRIPT> <% else sqldata="insert into course_schedule3(id_course_eng,id_schedule,id_date,sec_tion,time_learn,room_learn,room_test,stu_learn) values('"&id_course_eng&"','"&id_schedule&"','"&id_date&"', '"&sec_tion&"','"&time_learn&"','"&room_learn&"','"&room_test&"','"&stu_learn&"')" set orsdata = Server.CreateObject("adodb.recordset") orsdata.open sqldata,conn,1,3 response.write sqldata response.write "<meta http-equiv='refresh' content ='0;url=add_schedule1.asp?id_course_eng="&id_course_eng&"&id_schedule="&id_schedule&"'>" end if 'end if set conn = nothing 'ors_data.close %> <% else '���Է� response.write "<tr><td colspan=3><center>�س������Է����� �س���ѵԹ��" response.write "<meta http-equiv=refresh content =4;url=javascript:history.back();>" '���Է� end if '���Է� %>