请教一个模糊搜索问题,谢谢了
刚做了个模精搜索,我想实现逐字搜索功能,比如"2008年中国年度人物评选活动开始"这句话,如果能实现搜索"中国人物"或者"年度活动"等等这样分词的搜索也能成功,请问怎么办,下面哪里错了,以下是我的搜索代码.谢谢了
<%
dim i
Search=trim(request("search"))
search = Split(search,",")
if search <> "" then
for i=1 to ubound(search)
sql="SELECT * FROM query where title like '%"&search(i)&"%' or keywords like '%"&search(i)&"%' order by ID desc"
next
else
sql="SELECT * FROM query order by ID desc"
end if
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<p>很抱歉!根据您输入的关键词没有查询到相关结果!"
else
'------------------分页-----------------------------
rs.pagesize=List_pagecount
page=cint(request("page"))
if page<=0 or page>rs.pagecount or page="" then
page=1
end if
rs.absolutepage=page
Tdcount=0
for i=1 to rs.pagesize
if rs.eof then
exit for
else
response.write " ·<a href='"&rs("links")&"' target=_blank title='"&rs("title")&"'>"&rs("title")&"</a><br>"
Tdcount=Tdcount+1
if Tdcount>=5 then
response.write "<br>"
Tdcount=0
end if
rs.movenext
end if
next
response.write "<br>"
call pagelist()
end if
rs.close
%>