Editing: rp_add_qe.asp

<% date_exitexam=request.form("date_exitexam") date1=left(date_exitexam,2) month1=mid(date_exitexam,4,2) year_b4=right(date_exitexam,4) if date1=1 then date1="01" elseif date1=2 then date1="02" elseif date1=3 then date1="03" elseif date1=4 then date1="04" elseif date1=5 then date1="05" elseif date1=6 then date1="06" elseif date1=7 then date1="07" elseif date1=8 then date1="08" elseif date1=9 then date1="09" end if if month1=1 then month1="01" elseif month1=2 then month1="02" elseif month1=3 then month1="03" elseif month1=4 then month1="04" elseif month1=5 then month1="05" elseif month1=6 then month1="06" elseif month1=7 then month1="07" elseif month1=8 then month1="08" elseif month1=9 then month1="09" end If date_pass=year_b4+month1+date1 date_create=Now() sqla="select * from rp_qe_test order by id_report asc" Set orsa=server.createobject("adodb.recordset") orsa.open sqla,conn,1,3 If Not orsa.eof Then orsa.movelast id_report=orsa("id_report") Else id_report=1 End if 'Response.write datebegin&"+"&date_exitexam&"+"&""&"" sqlt="select * from rp_qe_test where id_activity='"&id_activity&"'" Set orst=server.createobject("adodb.recordset") orst.open sqlt,conn,1,3 'Response.write sqlt If Not orst.eof Then sqlt1="update rp_qe_test set date_pass='"&date_pass&"', d_pass='"&date1&"', m_pass='"&month1&"', date_create='"&date_create&"', y_pass='"&year_b4&"', id_status='1', id_qe_type1='"&id_activity_r&"' where id_activity='"&id_activity&"'" Set orst1=server.createobject("adodb.recordset") orst1.open sqlt1,conn,1,3 Response.write sqlt1 Else sqlt1="insert into rp_qe_test (id_report,id_activity, date_pass, d_pass, m_pass,id_status, y_pass, date_create,id_qe_type1) values("&id_report&",'"&id_activity&"','"&date_pass&"','"&date1&"', '"&month1&"', '1' , '"&year_b4&"','"&date_create&"','"&id_activity_r&"')" Response.write sqlt1 Set orst1=server.createobject("adodb.recordset") orst1.open sqlt1,conn,1,3 End if %>