这个~~~我给你看看吧!
下面那个希望能对你有启示!
search.asp
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
Dim reshop__MMColParam
reshop__MMColParam = "1"
If (Request.Form("UserId") <> "") Then
reshop__MMColParam = Request.Form("UserId")
End If
%>
<%
Dim reshop__MMColParam1
reshop__MMColParam1 = "UserId"
If (Request.Form("type") <> "") Then
reshop__MMColParam1 = Request.Form("type")
End If
%>
<%
Dim reshop
Dim reshop_numRows
Set reshop = Server.CreateObject("ADODB.Recordset")
reshop.ActiveConnection = MM_shop_STRING
reshop.Source = "SELECT * FROM RegUser WHERE "&reshop__MMColParam1&" LIKE '%" + Replace(reshop__MMColParam, "'", "''") + "%'"
reshop.CursorType = 0
reshop.CursorLocation = 2
reshop.LockType = 1
reshop.Open()
reshop_numRows = 0
%>