IF statement
<%
if request.form("via") = "" and request.form("season") = "" and request.form("cabin") = "" then
set rs1=con.Execute("select * from net_fares where air_cd = '"& air_cds &"' and company_id = '"& company_id &"' and contract_id = '"& contract_id &"' and dep like '%"& dep &"%' and arr like '%"& arr &"%'")
response.Write "" & ("select * from net_fares where air_cd = '"& air_cds &"' and company_id = '"& company_id &"' and contract_id = '"& contract_id &"' and dep like '%"& dep &"%' and arr like '%"& arr &"%'")& "<br>"
end if
if request.form("via") = "" and request.form("season") = "" then
set rs1=con.Execute("select * from net_fares where air_cd = '"& air_cds &"' and company_id = '"& company_id &"' and contract_id = '"& contract_id &"' and dep like '%"& dep &"%' and arr like '%"& arr &"%' and cabin = '"& cabin &"'")
response.write "" & ("select * from net_fares where air_cd = '"& air_cds &"' and company_id = '"& company_id &"' and contract_id = '"& contract_id &"' and dep like '%"& dep &"%' and arr like '%"& arr &"%' and cabin = '"& cabin &"'")& "<br>"
end if
if request.form("via") = "" and request.form("cabin") = "" then
set rs1=con.Execute("select * from net_fares where air_cd = '"& air_cds &"' and company_id = '"& company_id &"' and contract_id = '"& contract_id &"' and dep like '%"& dep &"%' and arr like '%"& arr &"%'")
response.write "" & ("select * from net_fares where air_cd = '"& air_cds &"' and company_id = '"& company_id &"' and contract_id = '"& contract_id &"' and dep like '%"& dep &"%' and arr like '%"& arr &"%'")& "<br>"
end if
if request.form("season") = "" and request.form("cabin") = "" then
set rs1=con.Execute("select * from net_fares where air_cd = '"& air_cds &"' and company_id = '"& company_id &"' and contract_id = '"& contract_id &"' and dep like '%"& dep &"%' and arr like '%"& arr &"%' and via = '"& via &"'")
response.write "" & ("select * from net_fares where air_cd = '"& air_cds &"' and company_id = '"& company_id &"' and contract_id = '"& contract_id &"' and dep like '%"& dep &"%' and arr like '%"& arr &"%' and via = '"& via &"'")& "<br>"
end if
if request.form("via") = "" then
set rs1=con.Execute("select * from net_fares where air_cd = '"& air_cds &"' and company_id = '"& company_id &"' and contract_id = '"& contract_id &"' and dep like '%"& dep &"%' and arr like '%"& arr &"%' and season = '"& season &"' and cabin = '"& cabin &"'")
response.write "" &("select * from net_fares where air_cd = '"& air_cds &"' and company_id = '"& company_id &"' and contract_id = '"& contract_id &"' and dep like '%"& dep &"%' and arr like '%"& arr &"%' and season = '"& season &"' and cabin = '"& cabin &"'")& "<br>"
end if
if request.form("season") = "" then
set rs1=con.Execute("select * from net_fares where air_cd = '"& air_cds &"' and company_id = '"& company_id &"' and contract_id = '"& contract_id &"' and dep like '%"& dep &"%' and arr like '%"& arr &"%' and via like '%"& via &"%' and cabin = '"& cabin &"'")
response.write "" & ("select * from net_fares where air_cd = '"& air_cds &"' and company_id = '"& company_id &"' and contract_id = '"& contract_id &"' and dep like '%"& dep &"%' and arr like '%"& arr &"%' and via like '%"& via &"%' and cabin = '"& cabin &"'")& "<br>"
end if
if request.form("cabin") = "" then
set rs1=con.Execute("select * from net_fares where air_cd = '"& air_cds &"' and company_id = '"& company_id &"' and contract_id = '"& contract_id &"' and dep like '%"& dep &"%' and arr like '%"& arr &"%' and via like '%"& via &"%' and season = '"& season &"'")
response.write "" &("select * from net_fares where air_cd = '"& air_cds &"' and company_id = '"& company_id &"' and contract_id = '"& contract_id &"' and dep like '%"& dep &"%' and arr like '%"& arr &"%' and via like '%"& via &"%' and season = '"& season &"'")& "<br>"
end if
if not rs1.eof then
%>
when the 'end if' occurs should that not stop the cycle?
will it then go onto the next IF statment?
can this be stopped?
|
