支持加号空格的查询
来源:
中文源码网 浏览:377 次 日期:2024-04-19 05:40:41
【下载文档: 支持加号空格的查询.txt 】
支持加号空格的查询
复制代码 代码如下:<% Response.write "关键字:("&trim(request("Q"))&")"&"
" 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)&"
" SQL=SQL&" or title like '"&t(i)&"'" '这个是关键end if next Response.write SQL %>