Editing: finance/add_rp_group_sub.asp

<!--#INCLUDE FILE="ConnectDB.asp"--> <% ypay=session("ypay") id_budget_type=session("id_budget_type") id=session("id_rp_group") username=session("username") id_paysub_sub=request.form("id_paysub_sub") date_mo=now sql="select * from rp_group_sub where id_rp_group='"&id&"' and ypay='"&ypay&"' and id_budget_type='"&id_budget_type&"' and id_paysub_sub='"&id_paysub_sub&"'" set ors=server.createobject("adodb.recordset") ors.open sql,conn,1,3 if ors.eof then sqldata="insert into rp_group_sub(username,ypay,id_budget_type,id_paysub_sub,date_mo,id_rp_group) values('"&username&"','"&ypay&"','"&id_budget_type&"','"&id_paysub_sub&"','"&date_mo&"','"&id&"')" 'response.write sql set orsdata = Server.CreateObject("adodb.recordset") response.write "<br>�ѹ�֡���������º���¤��"'&sqldata orsdata.open sqldata,conn,1,3 else response.write "�����ū��" end if response.write "<meta http-equiv='refresh' content ='2;url=add_rp_group_form.asp'>" %>