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

[求助] 操作苻丢失错误

威龙嘉少 发布于 2007-10-10 08:09, 464 次点击

错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'zt_ id = 1' 中。
/lt_topiclist.asp, 第 41 行
这几行的代码:
Set toplist = Server.CreateObject("ADODB.Recordset")
toplist.ActiveConnection = MM_web_STRING
toplist.Source = "SELECT * FROM zhuti WHERE zt_ id = " + Replace(toplist__MMColParam, "'", "''") + " ORDER BY zt_ id DESC"
toplist.CursorType = 0
toplist.CursorLocation = 2
toplist.LockType = 1
toplist.Open()

toplist_numRows = 0
%>
这有什么问题呢 ?
请指教啊!

3 回复
#2
tianyu1232007-10-10 08:56

toplist.Source = "SELECT * FROM zhuti WHERE zt_ id ="& Replace(toplist__MMColParam, "'", "''") &" ORDER

BY zt_ id DESC"
#3
天涯听雨2007-10-10 09:41
又是一个DW自动生成源码的。。。
#4
tianyu1232007-10-10 12:17

.................................
1