可以实现搜索的功能，但是怎么限制搜索条件？
我现在能实现搜索显示了，但是怎么限制搜索条件啊？把不输入搜索内容和输入表里没有的内容的两种情况限制住，现在总是报错！并且能够在不输入搜索内容的时候显示第一个表，就是正常的列表显示；按标题搜索的话显示第二个表，按内容搜索的话显示第三个表！在不跳转页面的情况下！我的代码如下：
<form name="aa" action="shdt_list.asp" method="post">
<td width="144" align="right">
信息搜索：</td>
<td width="302" align="center">
<input onblur="if(this.value==''){this.value=this.defaultValue;};this.className='c1';target_email()"
onfocus="if(this.value==this.defaultValue){this.value='';};this.className='c2';"
value="请在这里输入需搜索的内容" type="text" class="srk" size="50" id="qyname" name="qyname"></td>
<td width="59"><select id="select1" name="select1" onChange="MM_jumpMenu('parent',this,0)">
<option value="1" selected="selected">标题</option>
<option value="2">内容</option>
</select></td>
<td width="89"><input border=0
name="bb" src="Images/ss.png" width="49" height="19" type="image" ></td>
</form>
</tr>
</table>
</td>
</tr>
<tr>
<%
types=request.Form("select1")
names=trim(request.Form("qyname"))
if types="" then %>
<td height="606" class="INPUT01" align="center">
<table width="638" height="306" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="638" height="641" valign="top">
<% Dim sql %>
<% set rs=server.createobject("adodb.recordset")
sql="select * from gsl_xwen where gsl_lb=28 order by gsl_id desc "
rs.open sql,conn,1,3
rs.pagesize=20
if request("page")<>"" then
epage=cint(request("page"))
if epage<1 then epage=1
if epage>rs.pagecount then epage=rs.pagecount
else
epage=1
end if
rs.absolutepage=epage
if not rs.bof then
for i=0 to rs.pagesize-1
if rs.bof or rs.eof then exit for %>
<table width="641" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="30" class="jiage" align="center">
<img src="Images/arrow_6.gif" width="11" height="11"></td>
<td width="611" class="jiage" height="31">
<a href="shdt_view.asp?cph=<%=rs("gsl_id")%>" class="link" target="_blank">
<%=left(rs("gsl_news_title"),35)%>
</a>
<%if DateValue(rs("gsl_time"))=>DateValue(date()-0) then
Response.Write "<img src=""Images/kcnew.gif"" width=""23"" height=""11"">"
%>
<%end if%>
</td>
</tr>
</table>
<% rs.movenext()
next %>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="31" class="INPUT01" align="center">
<table width="545" height="25" border="0" cellpadding="0" cellspacing="4">
<tr>
<form method="Post" action="shdt_list.asp?BigClass=<%=BigClass%>&SmallClass=<%=SmallClass%>">
<td width="40" align="center">
<a href="shdt_list.asp?page=1" class="link">首页
</td>
<td width="60" align="center">
<a href="shdt_list.asp?page=<%=epage-1%>" class="link">上一页</td>
<td width="60" align="center">
<a href="shdt_list.asp?page=<%=epage+1%>" class="link">下一页</td>
<td width="46" align="center">
<a href="shdt_list.asp?page=<%=rs.pagecount%>" class="link">尾页</td>
<td width="140" height="22" align="center">
共有<%=rs.pagecount%>页 当前第<%=epage%>页
</td>
<td width="100" align="center">
共<%=rs.RecordCount %>条记录</td>
<td width="100" align="center">
<%=rs.PageSize %>
条记录/页</td>
<td width="18" align="center">
<input type='text' name='page' size="4" maxlength="10">
</td>
<td width="51" align="center">
<input class="input" type='submit' value='Go' name='cndok'>
</td>
</form>
</tr> <%end if
rs.close() %>
</table>
</td>
</tr>
</table>
<%else if types="1" then%>
上面表单下面的那个表：<table> 部分代码如下： <% dim sql1 %>
<% set rs=server.createobject("adodb.recordset")
sql1="select * from gsl_xwen where gsl_lb=28 and gsl_news_title like '%"&names&"%' order by gsl_id desc "
rs.open sql1,conn,1,3
rs.pagesize=20后面为分页代码
</table>
<%
else if types="2" then
%>
还是上面那个表<table> 部分代码： <%Dim sql2%>
<% set rs=server.createobject("adodb.recordset")
sql2="select * from gsl_xwen where gsl_lb=28 and gsl_news_content like '%"&names&"%' order by gsl_id desc "
rs.open sql2,conn,1,3
rs.pagesize=20后面为分页代码
<% end if
end if
%>
[解决办法]
你在搜索到事件里判断 要按什么条件去查询 返回处查询的记录再绑定呀
