ASP一个简单的模糊搜索，请指教菜鸟
问题:搜就一个筐，写关键字。<table width="216" height="26" border="0" align="center" cellpadding="0" cellspacing="0">
<form name="form2" method="post" action="rexsearchp.asp">
<tr>
<td width="155" height="19" align="right" valign="top">
<div align="center">
<input class=wenbenkuang name="searchkey" style="FONT-SIZE: 9pt; BACKGROUND-COLOR: #ffffff" type="text" size=22>
</div></td>
<td width="61" align="center" valign="top">
<input name="submit" type="image" src="pic/xiao/seachso.gif" align="absmiddle" width="57" height="19" border="0"></td>
</tr>
</form>
</table>
接收该怎么写啊？
这样么？
<%
dim searchkey
searchkey=request("searchkey")
if InStr(searchkey,"'")>0 then
response.write"<script>alert(""非法访问!"");location.href=""../index.asp"";</script>"
response.end
end if
%>
<%sqltext="select * from cp where "&cp_name&" like '%"&searchkey&"%'"
set rs=server.createobject("adodb.recordset")
rs.open sqltext,conn,1,1
do while not rs.eof
%>
<%=rs("cp_name")%>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
最佳答案：
<!--#include file='(如conn.asp)'-->
<%
set rs=server.createobject("adodb.recordset")
rs.open "select * from [表] where [字段名] like '%"&request('searchkey')&"%'",conn,1,1
do while not rs.eof
response.write rs("cp_name")
rs.movenext
loop
rs.close
set rs=nothing
回答2: <%
dim searchkey
searchkey=trim(request.form("searchkey"))
sub=request("submit")
set rs=server.createobject("adodb.recordset")
if sub<>"" then
if searchkey="" then
response.write"alert("没有输入查询的关键字");history.back();"
end if
sqltext="select * from cp where cp_name like '%"&searchkey&"%'"
else
sqltext="select * from cp"
end if
rs.open sqltext,conn,1,1
do while not rs.eof
%>
<%=rs("cp_name")%>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>