<% Dim Recordset1 Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_conn_STRING Recordset1.Source = "SELECT bID, name, biaoti, book, replynumb, time, bookdetail.replynumb FROM bookdetail WHERE replynumb=0 AND (book LIKE '%" + Replace(Recordset1__MMColParam, "'", "''") + "%') OR (name LIKE '%" + Replace(Recordset1__MMColParam, "'", "''") + "%') OR (biaoti LIKE '%" + Replace(Recordset1__MMColParam, "'", "''") + "%') " Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 1 Recordset1.Open()

Recordset1_numRows = 0 %> 为什么WHERE子句中replynumb=0不起作用,即在测试时,replynumb<>0的也被列出.