UC知道asp搜索源码
来源：百度知道 编辑：UC知道 时间：2024/05/15 23:28:31
前台：<input type="text" name="key" size="19" class="input">
<select name="otype" class="input">
<option value="title" selected class="input">信息标题</option>
<option value="content" class="input">信息内容</option>
</select>
<input type="submit" name="Submit" value="搜索" class="input">
后台：<%
Set rs= Server.CreateObject("ADODB.Recordset")
if otype="title" then
sql="select * from NEWS where title Like '%"& key &"%' order by id desc"
elseif otype="msg" then
sql="select * from NEWS where content Like '%"& key &"%' order by id desc"
else
end if
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<
<select name="otype" class="input">
<option value="title" selected class="input">信息标题</option>
<option value="content" class="input">信息内容</option>
</select>
<input type="submit" name="Submit" value="搜索" class="input">
后台：<%
Set rs= Server.CreateObject("ADODB.Recordset")
if otype="title" then
sql="select * from NEWS where title Like '%"& key &"%' order by id desc"
elseif otype="msg" then
sql="select * from NEWS where content Like '%"& key &"%' order by id desc"
else
end if
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<
后台的错了，应该是：
<%
Set rs= Server.CreateObject("ADODB.Recordset")
if otype="title" then
sql="select * from NEWS where title Like '%"& key &"%' order by id desc"
elseif otype="content" then
sql="select * from NEWS where content Like '%"& key &"%' order by id desc"
else
end if
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<p align='center'>对不起，没有找到相关文章</p>"
else
%>
替换就可以了呵呵，你的if elseif else end if 里面有错误嘿嘿
后台：<%
Set rs= Server.CreateObject("ADODB.Recordset")
if otype="title" then
sql="select * from NEWS where title Like '%"& key &"%' order by id desc"
else
sql="select * from NEWS where content Like '%"& key &"%' order by id desc"
end if
rs.open