📄 disableproduct.asp
字号:
<!-- #include file="conn.asp" -->
<html>
<head>
</head>
<body>
<%
product_id = request.QueryString("productid")
Set oRs = Server.CreateObject("ADODB.RecordSet")
SQL = "select * from products where productid="&product_id
Set oRs = objcon.execute(SQL)
Set oRs2 = Server.CreateObject("ADODB.RecordSet")
oRs2.open "disabled",objcon, 2,3
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 products where productid="&product_id
objcon.execute(SQL)
response.redirect "deldis.asp"
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -