enableproduct.asp

来自「online sales system of texttile mill was」· ASP 代码 · 共 33 行

ASP
33
字号
<!-- #include file="conn.asp" -->
<html>
<head>
</head>
<body>
<%
product_id = request.QueryString("product_id")
Set oRs = Server.CreateObject("ADODB.RecordSet")
SQL = "select * from disabled where productid="&product_id
Set oRs = objcon.execute(SQL)
Set oRs2 = Server.CreateObject("ADODB.RecordSet")
oRs2.open "products",objcon, 2,3
	oRs2.AddNew

oRs2.AddNew
	oRs2.Fields("productid") = oRs.Fields("productid")
	oRs2.Fields("Name") = oRs.Fields("name")
	oRs2.Fields("Quality") = oRs.Fields("Quality")
	oRs2.Fields("Price") = oRs.Fields("price")
	oRs2.Fields("imagePath") = oRs.Fields("imagepath")
	oRs2.Fields("techId") = oRs.Fields("techid")
  	oRs2.Fields("type") = oRs.Fields("type")
	oRs2.Update
oRs2.close
oRs.close
SQL = "delete * from disabled where product_id="&product_id
objCon.execute(sql)

response.redirect "enable.asp"
%>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?