急！在线等

Question

if request("pinyin")<>"" then
   condition1=" and 字段1='"&request("pinyin")&"'"
else
   condition1=""
end if 
         
if  request("collectname")<>"" then
   condition2=" and 字段2='"&request("collectname")&"'"
else
   condition2=""
end if
       Query="select * from login  where 1=1  "+condition1+ condition2+conditon3+condition4

Answer 1

if request("pinyin")<>"" then
   condition1="字段1='"&request("pinyin")&"'"
else
   condition1="1=1"
end if 
         
if  request("collectname")<>"" then
   condition2="字段2='"&request("collectname")&"'"
else
   condition2="1=1"
end if

Answer 2

你仔细看看。在上面加and而不是在下面。

Answer 3

condition1=iif(request("pinyin")="",""," and 字段1='" & request("pinyin") &"'")
condition1=condition1 & iif(request("pinyin")="","",condition2=" and 字段2='"& request("collectname")&"'")
if condition1<>"" then condition1=" where " & mid(condition1,6)
Query="select * from login" & condition1