Editing: edit_advisor.asp.bak

<!--#INCLUDE FILE="Connectdb.asp"--> <form name="form1" Action = "detail_advisor.asp" method="post"> <% id_lecturer=request("id_lecturer") 'id_year=request("id_year") id_stugroup=request("id_stugroup") %> <% sql_data="select * from advisor_student where id_lecturer='"&id_lecturer&"'and 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('�ѹ�֡�����ū��');" response.write "window.location.href='add_advisor_form.asp';" %> --> </SCRIPT> <% else sqldata="insert into advisor_student(id_lecturer,id_stugroup,id_year) values('"&id_lecturer&"','"&_ id_stugroup&"','"&id_year&"')" 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_advisor.asp?id_lecturer="&id_lecturer&"&id_stugroup="&id_stugroup&"'>" end if 'end if set conn = nothing 'ors_data.close %> </FORM>