saveproductmod.asp

来自「人民医院眼科全站」· ASP 代码 · 共 37 行

<!-- #include file="../include/bkconn.asp "-->
<!--#include file="checkUser.asp"-->
<%
       Set cmdTemp = Server.CreateObject("ADODB.Command")
       Set InsertCursor = Server.CreateObject("ADODB.Recordset")
       cmdTemp.CommandText = "SELECT * FROM product WHERE id="&Request("id")
       cmdTemp.CommandType = 1
       Set cmdTemp.ActiveConnection = conn
       InsertCursor.Open cmdTemp, , 1, 3
	   InsertCursor("productSort") =Request("productSort")
       InsertCursor("name") =Request("name")
       InsertCursor("memberPrice") =Request("memberPrice")
       InsertCursor("costPrice") =Request("costPrice")
	   InsertCursor("spec") =Request("spec")
	   InsertCursor("vip") =Request("vip")
       InsertCursor("explain") =Request("explain")
	   InsertCursor("itemno") =Request("itemno")
	   InsertCursor("outer") =Request("outer")
	   InsertCursor("pinpai") =Request("pinpai")
	   InsertCursor("tejia") =Request("tejia")
	   InsertCursor("tejia1") =Request("tejia1")
	   InsertCursor("width") =Request("width")
	   InsertCursor("height") =Request("height")
	   InsertCursor("recommend") =Request("recommend")
	   InsertCursor("recommendDate") =Request("recommendDate")
       InsertCursor.Update
       InsertCursor.close
	   conn.close
       set InsertCursor=nothing
       set conn=nothing
%>
<script language=Javascript>
<!--
alert("修改成功！");
this.document.location="productlist.asp?id=<%=Request("id")%>";
-->
</script>