savemembermod.asp

来自「自己开发的一个网站数据库系统,希望和大家一块交流学习」· ASP 代码 · 共 32 行

<%
if session("admin_name")="" then response.end
%>
<!--#include file="conn.asp"-->
<%
       Set cmdTemp = Server.CreateObject("ADODB.Command")
       Set InsertCursor = Server.CreateObject("ADODB.Recordset")
       cmdTemp.CommandText = "SELECT * FROM member WHERE user_id="&Request("id")
       cmdTemp.CommandType = 1
       Set cmdTemp.ActiveConnection = conn
       InsertCursor.Open cmdTemp, , 1, 3
       InsertCursor("user_name") =Request("memberID")	   
       InsertCursor("user_namec") =Request("name")
       InsertCursor("user_pass") =Request("user_pass")
       InsertCursor("user_mail") =Request("email")
       InsertCursor("user_tel") =Request("phone")
       InsertCursor("user_adds") =Request("address")
       InsertCursor("user_postcode") =Request("code")
       InsertCursor.Update
       InsertCursor.close
	   conn.close
       set InsertCursor=nothing
       set conn=nothing
%>
<script language=Javascript>
<!--
alert("修改成功！");
this.document.location="<%=session("adminOldUrl")%>";
-->
</script>