在线求助大佬!两个if keywords 不兼容 不能同时使用
程序媛小白求助:[local]1[/local]
if keywords="" then
sql="select * from workflow where shenqingleixing='充值设定'"
else
sql="select * from workflow where shenqingleixing='充值设定' and shebei like '%" & keywords & "%' "
end if
if request("bjlx")="全部" or request("bjlx")="" then
else
sql=sql & " and dangqian='" & request("bjlx") & "'"
end if
sql=sql & " order by shenqingshijian desc"
if keywords<>"" then
sql="select * from workflow" & request("autoid") & " where qidongshijian>='"& rqs &" 00:00:00' and qidongshijian <='"&rqe&" 24:00:00' and (tip like '%"&keywords&"%' or labelcaption like '%"&keywords&"%') order by qidongshijian"
else
sql="select * from workflow" & request("autoid") & " where qidongshijian>='"& rqs &" 00:00:00' and qidongshijian <='"&rqe&" 24:00:00' order by qidongshijian"
end if
我也不知道是哪里出问题了这两个if keywords不能同时使用 求助!