sql语句的问题???在线等
在做查询时候,没有输入什么东东,但结果,把表中的所有记录都显示出来.
select * from toptitle where ifel=0 and title like '% "&keyword& "% ' order by addtime desc
用reponse.write 打印出来
select * from toptitle where ifel=0 and title like '%% ' order by addtime desc
在SQL查询分析器中显示全部记录,前台也是一样,不知道什么原因.
数据库是MSSQL
[解决办法]
如果keyword是空，那么
and title like '% "&keyword& "% '
相当于
and 1
[解决办法]
可以判断一下keyword的值是否为空!
[解决办法]
select * from toptitle where ifel=0 and title like ' "&keyword& " ' order by addtime desc
这样应该就不会了
[解决办法]
if Request( "keyword ") <> " " then
Sql = "select * from toptitle where ifel=0 and title like '% "&keyword& "% ' order by addtime desc "
else
Response.Write "没条件！ "
Response.End
end If
