如题，想要实现输入“关键字＋空格＋关键字”的查询方式，该如何实现呢？是不是先判断有无空白字，然后再用Replace()实现呢？

key=replace(replace(replace(replace(replace(replace(replace(request(keywords)," ","")," ","")," ","")," ","")," ","")," ","")," ","")
words=split(key," ")
sql="select * from table where 字段 like '%"&key&"%'"
for i= 0 to ubound(words)-1
sql=sql&" or 字段 like '%"&words(i)&"%'"
next
rs.open sql,conn,1,1

麻烦解释一下吧，谢谢了！有点看晕了

key=replace(replace(replace(replace(replace(replace(replace(request(keywords)," ","")," ","")," ","")," ","")," ","")," ","")," ","") '尽可能把多余的空格替换掉
words=split(key," ") '把输入的关键字按空格断成书组
sql="select * from table where 字段 like '%"&key&"%'" '先给一个条件 什么条件都行
for i= 0 to ubound(words)-1 '把数组循环取出
sql=sql&" or 字段 like '%"&words(i)&"%'"
next
rs.open sql,conn,1,1

split不是方便很多?

怎么个SPLITF法，说来听听

这个不好
仿百度这样是不够的 摆渡不用空格也行
要建立一个词库 把用户和自己总结的关键词放进去 搜索的时候先查关键词 在按全部符合、部分符合的方式检索

这样就不局限空格了
这个是我仿百度做的http://www.chinaqibao.net/search/
其实离百度的搜索还差的远 只是简单模仿

哦，明白了！

说说看嘛，大家讨论讨论！

islet 的就是split的呀

不过想学习一下islet 的关于防百度的,请islet 介绍一下,然后给点代码来看看,可以否?

[此贴子已经被作者于2006-6-12 11:40:07编辑过]