Editing: equipment_edit.asp.bak

<!--#INCLUDE FILE="Connectdb.asp"--> <!--#include file="inc_cache_control.asp"--> <!--#include file="inc_access_control.asp"--> <!--#include file="chk_login.asp"--> <% session("tb_name")="equipment"%> <!--#include file="chk_permission.asp"--> <% if session("tb_edit")=2 then '���Է��� �����㹰ҹ ��� ����Ңͧ�������ͧ %> <form name="form1" Action = "equipment_detail.asp?id_equipment=<%=id_equipment%>" method="post"> <% id_equipment=request.form("id_equipment") id_method=request.form("id_method") id_unit=request.form("id_unit") id_type=request.form("id_type") id_type_budget=request.form("id_type_unit") year_budget=request.form("year_budget") detail_retail=request.form("detail_retail") id_type_budget=request.form("id_type_budget") d_purchase=request.form("d_purchase") m_purchase = request.form("m_purchase") y_purchase =request.form("y_purchase") time_assure = request.form("time_assure") price = request.form("price") id_brand = request.form("id_brand") id_owner = request.form("id_owner") serial_eq = request.form("serial_eq") number=request.form("number") mem_m=request.form("mem_m") ram=request.form("ram") date_purchase=y_purchase&""&m_purchase&""&d_purchase place=request.form("place") id_status=request.form("id_status") more_detail=request.form("more_detail") d_retire=request.form("d_retire") m_retire=request.form("m_retire") y_retire=request.form("y_retire") date_retire=d_retire&"/"&m_retire&"/"&y_retire core_cpu=request.form("core_cpu") %> <% sqldata="update equipment set date_purchase='"&date_purchase&"',time_assure='"&time_assure&"', price='"&price&"',id_brand='"&id_brand&"',id_owner='"&id_owner&"',id_type='"&id_type&"',serial_eq='"&serial_eq&"',number='"&number&"',ram='"&ram&"',place='"&place&"',id_status='"&id_status&"',more_detail='"&more_detail&"',d_purchase='"&d_purchase&"',m_purchase='"&m_purchase&"',y_purchase='"&y_purchase&"',core_cpu='"&core_cpu&"',id_unit='"&id_unit&"',id_method='"&id_method&"',id_type_budget='"&id_type_budget&"',year_budget='"&year_budget&"',detail_retail='"&detail_retail&"',mem_m='"&mem_m&"',d_retire='"&d_retire&"',m_retire='"&m_retire&"',y_retire='"&y_retire&"',date_retire='"&date_retire&"' where id_equipment='"&id_equipment&"'" 'sqldata="insert into equipment(id_equipment,id_type,date_purchase,time_assure,price,id_brand,id_owner,serial_eq,number,ram,place,id_status,more_detail,d_purchase,m_purchase,y_purchase,core_cpu,id_unit,id_method,id_type_budget,year_budget,detail_retail) values('"&id_equipment&"','"&id_type&"','"&date_purchase&"','"&time_assure&"', '"&price&"','"&id_brand&"','"&id_owner&"','"&serial_eq&"','"&number&"','"&ram&"','"&place&"','"&id_status&"','"&more_detail&"','"&d_purchase&"','"&m_purchase&"','"&y_purchase&"','"&core_cpu&"','"&id_unit&"','"&id_method&"','"&id_type_budget&"','"&year_budget&"','"&detail_retail&"')" set orsdata = Server.CreateObject("adodb.recordset") orsdata.open sqldata,conn,1,3 response.write sqldata set conn = nothing response.write "<meta http-equiv='refresh' content ='0;url=equipment_detail.asp?id_equipment="&id_equipment&"'>" %> </FORM> <% else '���Է� response.write "<tr><td colspan=3><center>�س������Է����� �س���ѵԹ��" response.write "<meta http-equiv=refresh content =4;url=javascript:history.back();>" '���Է� end if '���Է� %>