支持加号空格的查询

2018-09-06 10:30

阅读:840

  复制代码 代码如下:
<%
Response.write关键字:(&trim(request(Q))&)&<hr>
x=Replace(trim(request(Q)),,,)
x=array(x)
t=split(x,,)
SQL=Select*FromTBwherekis<>0
fori=0toUBound(t)
ift(i)<>then
Response.write第&i+1&:&t(i)&<hr>
SQL=SQL&ortitlelike&t(i)& 这个是关键
endif
next
Response.writeSQL
%>
<Formaction=>
<table>
<tr>
<td><InputName=Qonkeyup=this.value=this.value.replace(/\s+/g,)><inputtype=submitvalue=查
询></td>
</tr>
</table>
</form>


评论


亲,登录后才可以留言!