Question

asp 多条件查询，很简单，一句话

rs.open "select * from kuaidi where fhr like '%"&selectkey&"%' or psgs like '%"&psgs&"%' order by id desc",conn,1,1

这样写对吗？同时查询2个条件以上，怎么写？

Answer 1

对的
rs.open "select * from kuaidi where userid="& userID &" and (fhr like '%"&selectkey&"%' or psgs like '%"&psgs&"%') order by id desc",conn,1,1

Answer 2

<%
selectkey=trim(request("selectkey"))
psgs=trim(request("psgs"))
sql="select * from kuaidi where ID>0 "
if selectkey<>"" then
sql=sql&"and fhr like '%"&selectkey&"%'"
end if
if psgs<>"" then
sql=sql&"and psgs like '%"&psgs&"%'"
end if
sql=sql & " order by id desc"
Set rs2= Server.CreateObject("ADODB.Recordset")
rs2.open sql,conn,1,1
%>
这样在有就再加
if psgs<>"" then
sql=sql&"and psgs like '%"&psgs&"%'"
end if
这样形式的语句

Answer 3

<%
selectkey=trim(request("selectkey"))
psgs=trim(request("psgs"))
sql="select * from kuaidi where ID>0 "
if selectkey<>"" then
sql=sql&"and fhr like '%"&selectkey&"%'"
end if
if psgs<>"" then
sql=sql&"and psgs like '%"&psgs&"%'"
end if
sql=sql & " order by id desc"
Set rs2= Server.CreateObject("ADODB.Recordset")
rs2.open sql,conn,1,1
%>