对象关闭时，操作不被允许？？？？ADODB.Recordset 错误 '800a0e78'

[cpplus]

<!-- #include file="../include/connection.inc" -->
<%

news_id = request.querystring("id")
response.write "news id="&news_id
set rs_news = Server.CreateObject("ADODB.Recordset")
sql_news_delete = "DELETE FROM news where id='"&news_id&"'"

rs_news.open sql_news_delete,con
rs_news.Close ''''就是这一句说是对象关闭时，操作不被允许。
set rs_news = nothing

con.Close
set con = nothing

response.write "删除新闻操作成功！正在返回......"
%>

[karma]

<%
news_id = request.querystring("id")
response.write "news id="&news_id
sql_news_delete = "DELETE FROM news where id=" & news_id
con.execute sql_news_delete
con.Close
set con = nothing
response.write "删除新闻操作成功！正在返回......"
%>

[tripofdream]

DELETE不返回记录集

[jinchaohua]

是啊，进行delete、update操作后，recordset对象是关闭的，即rs_news.Close不用写了，直接写set rs_news = nothing就可以了！

[kickken]

　tripofdream(梦之旅)　说的没错。DELETE 操作的 OPEN 无须 CLOSE

[freezwy]

这种语句的最简单用法是这样的。
con.execute("delete from news where id="&news_id)
不必使用rs.

[cpplus]

哦，这个样子呀~~~

谢谢，谢谢大家~~~~