Editing: grade/add_grade_e.asp.bak

<!--#INCLUDE FILE="ConnectDB.asp"--> <% semeter=session("semeter") id_course=request.form("id_course") id_year=session("id_year") grade=request.form("grade") sql_c="select * from register where re_year="&id_year&" and id_course='"&id_course&"' and semeter="&semeter&"" set ors_c=server.createobject("adodb.recordset") ors_c.open sql_c,conn,1,3 if ors_c.eof then 'date_mo=now 'username=session("username") sqldata="insert into register(re_year,semeter,id_course,grade) values('"&id_year&"','"&semeter&"','"&id_course&"','"&grade&"')" 'response.write sqldata set orsdata = Server.CreateObject("adodb.recordset") orsdata.open sqldata,conn,1,3 %> <SCRIPT LANGUAGE="JavaScript"> <% response.write "alert('�ѹ�֡���������º����');" %> --> </SCRIPT> <% response.write "<meta http-equiv='refresh' content ='0;url=add_grade_form.asp'>" %><% else %> <SCRIPT LANGUAGE="JavaScript"> <% response.write "alert('�ѹ�֡�������Ԫҹ�������');" response.write "window.location.href='add_grade_form.asp';" %> </SCRIPT> <% end if %>