汗!!你条件多,哪有什么简单的!!
最简单的就是
sql = "select * from prodad where 1=1"
if request("zs_sort") <> "" then
sql = sql&" and zs_sort = "&request("zs_sort")&""
else
sql = sql
end if
if request("wy_sort") <> "" then
sql = sql&" and wy_sort = "&request("wy_sort")&""
else
sql = sql
end if
[Quote=引用 8 楼 lingyun410 的回复:]
引用 1 楼 sy_binbin 的回复:
sql = "select * from prodad where 1=1"
if request("zs_sort") <> "" then
sql = sql&" and zs_sort = "&request("zs_sort")&""
else
sql = sql
end if
if request("wy_sort") <> "" then
sql = sql&" and wy_sort = "&request("wy_sort")&""
else
sql = sql
end if
[Quote=引用 1 楼 sy_binbin 的回复:]
sql = "select * from prodad where 1=1"
if request("zs_sort") <> "" then
sql = sql&" and zs_sort = "&request("zs_sort")&""
else
sql = sql
end if
if request("wy_sort") <> "" then
sql = sql&" and wy_sort = "&request("wy_sort")&""
else
sql = sql
end if
sql = "select * from prodad where 1=1"
if request("zs_sort") <> "" then
sql = sql&" and zs_sort = "&request("zs_sort")&""
else
sql = sql
end if
if request("wy_sort") <> "" then
sql = sql&" and wy_sort = "&request("wy_sort")&""
else
sql = sql
end if