注册 登录
编程论坛 ASP技术论坛

下面的代码错在哪里?

ljq2222 发布于 2008-07-24 12:18, 704 次点击
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC 驱动程序不支持所需的属性。
/admin/admin_infodel.asp, 第 4 行



下面是源码,请大家看看错在哪里?
<!--#include file="adminconn.inc"-->
<%
set rs=server.CreateObject("ADODB.RecordSet")
rs.open "delete * from NEWS where n_id="&request.QueryString("n_id"),conn,1
set rs=nothing
response.write "<script language='javascript'>" & chr(13)
        response.write "alert('成功删除!');" & Chr(13)
        response.write "window.document.location.href='admin_info.asp';"&Chr(13)
        response.write "</script>" & Chr(13)
Response.End
%>
3 回复
#2
multiple19022008-07-24 12:37
很好奇地问一下,为什么那么多人不喜欢用又简洁又不容易出错的Conn.Execute来执行查询,尤其是那些非Select的查询?
#3
hmhz2008-07-24 12:48
好好看看置顶帖子,删除程序有这样写的吗?
set rs=server.CreateObject("ADODB.RecordSet")
rs.open "delete * from NEWS where n_id="&request.QueryString("n_id"),conn,1
set rs=nothing
1