asp.vbs+access模糊查询出错?
下面是我用DW视图建立的模糊查询出来的代码,可出错!希望大家帮忙看下,还有感觉视图建立的代码好多·手工我又不知道写····<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_conn_STRING
Recordset1.Source = "SELECT * FROM fuwu WHERE SHUJU like %" + Replace(Recordset1__MMColParam, "'", "''") + "% ORDER BY ID DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
错误提示代码:
- 错误类型:
Microsoft JET Database Engine (0x80040E14)
语法错误 在查询表达式 'SHUJU like %1%' 中。
/chazhao.asp, 第 40 行 - 浏览器类型:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) - 网页:
POST 78 ??? /chazhao.asp - POST Data:
textfield=%C8%FD%D1%C7%D6%D0%B7%A8%B9%A9%CB%AE%B9%AB%CB%BE&Submit=%B2%E9%D5%D2 - 时间:
2012年3月20日, 23:25:11