?? editpersoninfindb.asp
字號:
<!--#include file="include/sqlstr.asp"-->
<!--#include file="include/bgsub.asp"-->
<!--#include file="include/opendb.asp"-->
<%
'-----------------------------------------
oabusyname=request("oabusyname")
oabusysuid=request("oabusysuid")
oabusyuserdept=request("oabusyuserdept")
oabusyuserlevel=request("oabusyuserlevel")
'--------------------------------------
%>
<%'獲取數據
dim a(33)
for i=1 to 33
a(i)=request.form("a"&i)
'response.write a(i)
next
id=request("id")
if id="" then id=oabusysuid
set conn=opendb()
set rs=server.createobject("ADODB.recordset")
sql = "select * from personinf where suid=" & sqlstr(id)
rs.Open sql,conn,1,3
'如果沒有相應的紀錄
if not rs.eof then
for i=1 to 33
rs("a" & i)=a(i)
next
rs("updatedate")=now()
rs.update
end if
rs.close
set rs=nothing
set conn=nothing
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<div align="center">
<p>信息已經修改成功!!</p>
<p><a href="upload/index.asp?id=<%=id%>" target="_blank">上傳照片</a></p>
<p><a href="javascript:history.go(-1)">返回</a></p>
</div>
</td>
</tr>
</table>
<p> </p>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -