应为:
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_conn_1_STRING
Recordset1.Source = "SELECT * FROM tab WHERE name LIKE '%"&request("textfield")&"%' ORDER BY ID DESC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
If (Recordset1.EOF) Then
Response.Redirect("back.htm")
End If
%>