Question

ASP知识，怎样编写查询按钮

我想做一个网页，里面有一个查询按钮，当用户输入查询条件时，想用它从数据库中查询出相关信息，数据库：customlist,用到的表custom，
高手回答的时候可以不按我的数据库，按你们自己的也行

Answer 1

模糊搜索：
index.html:
<form id="form1" name="form1" method="get" action="SCategory.asp">
<div>
<div align="center">
<input name="mc" type="text" id="mc" />
<input type="submit" value="搜索" />
</div>
</div>
</form>
SCategory.asp:
<%
Dim rs4__MMColParam
rs4__MMColParam = "1"
If (Request.QueryString("mc") <> "") Then
rs4__MMColParam = Request.QueryString("mc")
'else
' rs4__MMColParam="1"
End If
%>
<%
Dim rs4
Dim rs4_numRows

Set rs4 = Server.CreateObject("ADODB.Recordset")
rs4.ActiveConnection = customlist
rs4.Source = "SELECT * FROM custom WHERE mc like '%"& rs4__MMColParam &"%'"
rs4.CursorType = 0
rs4.CursorLocation = 2
rs4.LockType = 1
rs4.Open()

rs4_numRows = 0
%>

Answer 2

<%
set rs=conn.execute("select * from custom")
if not rs.eof then
do while not rs.eof
response.write rs(0)
rs.movenext
loop
end if
%>

Answer 3

这是SQL问题,好好研究一下,sql的模糊查询就好了