新闻管理系统的新闻删除成功问题??
news_del_ok.asp
<!--#include file="Connections/news.asp" -->
<%
if(request.form("news_ID") <> "") then Command1__mynews_ID = request.form("news_ID")
%>
<%
set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_news_STRING
Command1.CommandText = "DELETE FROM news WHERE news_ID=" + Replace(Command1__mynews_ID, "'", "''") + " "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute() 这行问题
%>
<title>删除成功</title>
<center><p>删除成功</p>
<p><a href="news_edit.asp">返回</a></p>
</center>
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'news_ID=' 中。
/fx20110110/news_del_ok.asp, 第 15 行
请问各位大侠,这个我要怎么修改?
[解决办法]
Command1.CommandText = "DELETE FROM news WHERE news_ID='" + Replace(Command1__mynews_ID, "'", "''") + "'"