asp多条件查询sql语句用法，可用于搜索、筛选模块

big_id=trim(request("big_id"))
small_id=trim(request("small_id"))
key=trim(request("key"))
yongtu=trim(request("yongtu"))
chudian=trim(request("chudian"))
dianliu=trim(request("dianliu"))
dianya=trim(request("dianya"))


Set Rs=Server.CreateObject("ADODB.Recordset")
	
sql="select * from yuzhiguo_products where 1=1"

if big_id<>"" then sql=sql&" and big_id="&big_id&""

if small_id<>"" then sql=sql&" and small_id="&small_id&""

if yongtu<>"" then sql=sql&" and yongtu="&yongtu&""

if chudian<>"" then sql=sql&" and chudian="&chudian&""

if dianliu<>"" then sql=sql&" and dianliu="&dianliu&""

if dianya<>"" then sql=sql&" and dianya="&dianya&""

if key<>"" then sql=sql&" and ( e_cpmc like '%"&key&"%') "

sql=sql&" order by "&paixu&" desc,id desc"