Question

asp 从数据库中删除数据

<!--#include file="inc/conn.asp"-->
<%
set rs=server.CreateObject("adodb.recordset")
rs.open "delete * from orders where username='"&request.cookies(cookieName)("username")&"'",conn,1,3
rs.close
set rs=nothing
conn.close
response.Cookies(cookieName).Expires = NOW() -1
response.Cookies(cookieName)("username")=""
response.redirect "index.html"
%>
就是rs.close的那一行总提示对象关闭时不允许操作。但是数据库里的数据已经删除了。

Answer 1

删除不要用recordset,
改成这样多简单。
<!--#include file="inc/conn.asp"-->
<%
conn.execute "delete * from orders where username='"&request.cookies(cookieName)("username")&"")&"'"
conn.close
response.Cookies(cookieName).Expires = NOW() -1
response.Cookies(cookieName)("username")=""
response.redirect "index.html"
%>

Answer 2

代码简化一下：
conn.execute("delete * from orders where username='"&request.cookies(cookieName)("username")&"'")
response.Cookies(cookieName).Expires = NOW() -1
response.Cookies(cookieName)("username")=""
response.redirect "index.html"

Answer 3

<%
conn.execute ("delete * from orders where username='"&request.cookies(cookieName)("username")&"'")
response.Cookies(cookieName).Expires = NOW() -1
response.Cookies(cookieName)("username")=""
response.redirect "index.html"
%>

Answer 4

删除不要用recordset,直接用conn.execute(sql)即可