Question

sql查询语句 where后面跟多个条件 追100分~!

我想做一个查询的表格~点击A可查询数据库中有A的记录,点击B可查询数据库中有B的记录~!..有很多个
代码="SELECT * FROM X where A= '"+A+"' and B== '"+B+"'..."
代码是错的~!有人能帮我改改吗~!
谢谢~!
<%
if request("xh")=empty and request("yqmc")=empty and request("dj")=empty and request("gb")=empty then
Dim rs
Set rs= Server.CreateObject("ADODB.Recordset")
exec="SELECT top 20 * FROM zjb "
rs.open exec,conn,1,1
%>
..........
<%
else
Set rs= Server.CreateObject("ADODB.Recordset")
exec="SELECT top 20 * FROM zjb where xh='"+xh+"' & dj='"+dj+"' & yqmc='"+yqmc+"'"
rs.open exec,conn,1,1
%>
...........
<%
end if
%>
</body>
</html>

Answer 1

真晕~!
把where xh='"+xh+"' & dj='"+dj+"' & yqmc='"+yqmc+"'"改成where xh='"+xh+"' or dj='"+dj+"' or yqmc='"+yqmc+"'"就行了~!

Answer 2

代码="SELECT*FROM X WHERE= A LIKE('%A%') AND B LIKE('%B%')

Answer 3

http://www.chinesebloger.com