支持加号空格的查询

答案：
[复制此代码]CODE:

<% 
Response.write "关键字:("&trim(request("Q"))&")"&"<hr>" 
x=Replace(trim(request("Q"))," ",",") 
'x=array(x) 
t=split(x,",") 
SQL="Select * From TB where kis<>0" 
for i=0 to UBound(t) 
if t(i)<>"" then 
Response.write "第"&i+1&":"&t(i)&"<hr>" 
SQL=SQL&" or title like '"&t(i)&"'"  '这个是关键
end if 
next 
Response.write SQL 
%> 
<Form action=""> 
<table> 
<tr> 
<td><Input Name="Q" onkeyup="this.value=this.value.replace(/\s+/g,' ')"><input type="submit" value="查 
询"></td> 
</tr> 
</table> 
</form>

上一个：取得表单提交的所有数据
下一个：浏览文件夹下面所有图片