File Manager

<%
'*****************************************************************

session("tb_name")="course"
%>

<%
'*****************************************************************
  if session("tb_edit") <> 1 then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ

<form  name="form1"  Action = "detail_course.asp" method="post">
<%

id_course_th=request.form("id_course_th")
id_course_eng=request.form("id_course_eng")
course_th=request.form("course_th")
  course_eng = request.form("course_eng") 
  credit=request.form("credit")
  detail_coursee=request.form("detail_coursee")
  detail_courset=request.form("detail_courset")
  year_edu=request.form("year_edu")
  credit_sum=request.form("credit_sum")
id_course=id_course_eng+year_edu
  %>

<%
sql_data="select * from course where id_course='"&id_course&"' and year_edu='"&year_edu&"'"
	 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='add_course_form.asp';"
%>
		-->
		</SCRIPT>
		
		<%
else

sqldata="insert into course(id_course_th,id_course_eng,course_th,course_eng,credit,detail_coursee,year_edu,detail_courset,id_course,credit_sum)  values('"&id_course_th&"','"&_
  id_course_eng&"','"&course_th&"','"&_
  course_eng&"', '"&credit&"','"&detail_coursee&"','"&year_edu&"','"&detail_courset&"','"&id_course&"',"&credit_sum&")"

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_course.asp?id_course="&id_course&"'>"
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 =4;url=javascript:history.back();>" '���Է�
	end if '���Է�
%>

File Manager

Editing: add_course.asp.bak