Question

asp模糊搜索问题

获得参数 search 这样写不对
select * from KJDown_Soft where SoftName like ' "%"+"&search&"+"%" '
没写过asp代码,求正确写法

Answer 1

给个例子
t=request("name")
sql="select * from 表名 where 字段名 like ’%" +"&t& "+"%'"

Answer 2

应该是少了空格了"%"改成" % "就对了应该

Answer 3

select * from KJDown_Soft where SoftName like ‘%"&search&"%'“