File Manager

<%
		  pern=session("username")
		  per="2"
		  tb="project"
		  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
		  %>
<%
id_project=request.form("id_project")
project_name=request.form("project_name")
project_detail=request.form("project_detail")
project_year=request.form("project_year")
budget=request.form("budget")
real_budget=request.form("real_budget")
bdate=request.form("bdate")
bmonth=request.form("bmonth")
byear=request.form("byear")
edate=request.form("edate")
emonth=request.form("emonth")
eyear=request.form("eyear")
id_plan=request.form("d_fcontact")
id_budget=request.form("m_fcontact")
id_status=request.form("id_status")

date_mo=now

sqldata="update project set project_name='"&project&"',project_detail='"&project_detail&"',project_year='"&project_year&"',budget='"&budget&"',real_budget='"&real_budget&"',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: project_save_edit.asp