支持加号空格的查询

夏天的百皱裙照

2016-02-19 09:40

下面这个支持加号空格的查询教程由图老师小编精心推荐选出，过程简单易学超容易上手，喜欢就要赶紧get起来哦！

代码如下：

%
Response.write "关键字:("&trim(request("Q"))&")"&"hr"
x=Replace(trim(request("Q"))," ",",")
'x=array(x)
t=split(x,",")
SQL="Select * From TB where kis0"
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
tdInput Name="Q" onkeyup="this.value=this.value.replace(/s+/g,' ')"input type="submit" value="查
询"/td
/tr
/table
/form

展开更多（50%）