菜鸟求问!关于VBS的一点小问题!!!
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<meta http-equiv="Content-Type"content="text ml;charset=gb2312"/>
<!--#include virtual="/Connections/conn.asp" -->
<%
Set rs1 = Server.CreateObject ("ADODB.Command")
rs1.ActiveConnection = MM_conn_STRING
rs1.CommandText = "DELETE FROM book WHERE id = "&request("id")
rs1.CommandType = 1
rs1.CommandTimeout = 0
rs1.Prepared = true
rs1.Execute()
response.Redirect("msg.asp?info=留言删除成功<br><a href=admin.asp>返回留言管理</a>")
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" " http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns=" http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text ml; charset=utf-8" />
<title>无标题文档</title>
</head>
<body>
</body>
</html>
在DW中运行以上的代码时出现下面的错误提示。求如何解决这个问题??求正解啦!
——————————————————————————————————————————————
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'id =' 中。
/delete.asp, 第 13 行
——————————————————————————————————————————————