yuangonmodify_ok.asp

来自「20041230162250801409： 浙江省丽水市公铁联运有限公司OA系」· ASP 代码 · 共 46 行

<%@ language="vbscript"%>
<%response.Expires = 0%>

<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sqltext="select * from worker  where id=" & request.form("id")
rs.open sqltext,conn,3,3

'更新记录到数据库
rs("number")=request.form("aa")
rs("username")=request.form("bb")
rs("sex")=request.form("cc")
rs("zhuzhi")=request.form("dd")
rs("task")=request.form("ee")
rs("born_date")=request.form("ff")
rs("work")=request.form("gg")
rs("cellphone")=request.form("hh")
rs("office_tel")=request.form("ii")
rs("home_tel")=request.form("jj")
rs("email")=request.form("kk")
rs("body")=request.form("ll")
rs("marry")=request.form("mm")
rs("addrress")=request.form("nn")
rs("study")=request.form("oo")
rs("school")=request.form("pp")
rs("major")=request.form("qq")
rs("left_date")=request.form("rr")
rs("work_date")=request.form("ss")
if request("tt")="" then 
  rs("zhuche_date")="未登记"
  else
   rs("zhuche_date")=request("tt")
   end if 
'rs("zhuche_date")=request.form("tt")
rs("address")=request.form("uu")
rs.update
rs.close

response.redirect "../mannger/yuangon/yuangon.asp"
%>
<% rs.close
   set rs=nothing
   conn.close
   set conn=nothing
   %>