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

【求助】语法错误,操作符丢失,如何解决

WJayCL23 发布于 2011-05-05 09:56, 456 次点击
<%
Dim rs1
Dim rs1_cmd
Dim rs1_numRows

Set rs1_cmd = Server.CreateObject (")
rs1_cmd.ActiveConnection = MM_data_STRING
rs1_ = "SELECT ID, title, content, reply FROM book where ID=" &request("ID")
rs1_cmd.Prepared = true

Set rs1 = rs1_cmd.Execute
rs1_numRows = 0
%>

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'ID=' 中。
2 回复
#2
dzt00012011-05-05 10:42
这句 ID=" &request("ID")
request("ID")为空,SQL语句出错

 
#3
DanYang_dan2011-05-05 13:43
同楼上...
1