File Manager

<%
		  pern=session("username")
		  per="2"
		  tb="research"
		  sqlnc="select * from tb_permission where id_staff='"&pern&"' and tb_edit='"&per&"' and tb_name='"&tb&"'"
		  set orsnc=server.createobject("adodb.recordset")
		  orsnc.open sqlnc,conn,1,3
				if not orsnc.eof then
		  %>
<%
num_term=request.form("num_term")
id_contact=request.form("id_contact")
id_type_res=request.form("id_type_res")
research_t=request.form("research_t")
research_e=request.form("research_e")
id_capital_res=request.form("id_capital_res")
id_type_capital_res=request.form("id_type_capital_res")
y_capital_res=request.form("y_capital_res")
d_begin=request.form("d_begin")
m_begin=request.form("m_begin")
y_begin=request.form("y_begin")
amount=request.form("amount")
d_fcontact=request.form("d_fcontact")
m_fcontact=request.form("m_fcontact")
y_fcontact=request.form("y_fcontact")
username=session("username")
 date_mo=now

sqldata="update research set id_type_res='"&id_type_res&"',research_t='"&research_t&"',research_e='"&research_e&"',id_capital_res='"&id_capital_res&"',id_type_capital_res='"&id_type_capital_res&"',y_capital='"&y_capital_res&"',d_begin='"&d_begin&"',m_begin='"&m_begin&"',y_begin='"&y_begin&"',amount='"&amount&"',d_fcontact='"&d_fcontact&"',m_fcontact='"&m_fcontact&"',y_fcontact='"&y_fcontact&_
"',username='"&username&"',date_mo='"&date_mo&"',num_term='"&num_term&"' where id_contact='"&id_contact&"'"

set orsdata = Server.CreateObject("adodb.recordset")
 orsdata.open sqldata,conn,1,3
'response.write sqldata

%>
<SCRIPT LANGUAGE="JavaScript">
<%
response.write "alert('�ѹ�֡���������º����');"
%>
		
		</SCRIPT>
		<%
		response.write "<meta http-equiv='refresh' content ='0;url=detail_research.asp?id="&id_contact&"'>"

set conn = nothing
'ors_data.close

<%
else
%>
<SCRIPT LANGUAGE="JavaScript">
<%

response.write "window.location.href='index.html';"
		%>
		-->
		</SCRIPT>
		<%
end if

File Manager

Editing: save_edit_research.asp.bak