问一个SQL语句,按说下面的语句应该搜索所有的记录,但是现在只搜索出rank=2的记录而没有搜索rank=3和rank=4的记录
SELECT *
FROM Member
WHERE (MemberName LIKE '%%') AND (Rank = 2 OR
Rank = 3 OR
Rank = 4)
ORDER BY MemberID DESC
...全文
379打赏收藏
求一个SQL语句
问一个SQL语句,按说下面的语句应该搜索所有的记录,但是现在只搜索出rank=2的记录而没有搜索rank=3和rank=4的记录 SELECT * FROM Member WHERE (MemberName LIKE '%%') AND (Rank = 2 OR Rank = 3 OR Rank = 4) ORDER BY MemberID DESC
问题解决,另外一个问题,下面是从数据库里读出图片的一段代码,但当数据库里没有图片时在页面上就显示一个‘X’号,我想在输出前先做个判断,如果没有图片则输出 或“没有图片”,如果有就正常输出,下面的代码如何处理
sql="select * from company where postid='"&request("postid")&"'"
rs.open sql,conn,1,3
img=rs("logo")
Response.ContentType="image/*"
Response.BinaryWrite(img)
在查询分析器里测试SELECT * FROM Member WHERE (MemberName LIKE '%%') AND (Rank = 2 OR Rank = 3 OR Rank = 4) ORDER BY MemberID DESC是否成功查询?
如不行则查询SELECT * FROM Member WHERE (MemberName LIKE '%%') AND (Rank = 3 OR Rank = 4) ORDER BY MemberID DESC,看看出来什么