<% if (session("groupName")<>"Not selected" and session("placeName") <> "Not selected") then
sql =" select distinct dr.Down_P FROM Down_rate as dr,Total_list as tl, Price_list as pl WHERE dr.ID_Down = tl.Down_ID AND tl.Model_ID=pl.ID_Model and pl.Model='"&session("groupName")&"' and pl.Sub_Model ='" & session("placeName") & "' "
elseif (session("groupName")<>"Not selected" and session("placeName")="Not selected") then
sql =" select distinct dr.Down_P FROM Down_rate as dr,Total_list as tl, Price_list as pl WHERE dr.ID_Down = tl.Down_ID AND tl.Model_ID=pl.ID_Model and pl.Model='"&session("groupName")&"' "
else
sql= "select distinct dr.Down_P FROM Down_rate as dr "
end if
rs.Open sql, conn %>
The Pumps Program for the Chemical Industry
Customer Focused with innovative , Product Solutions
based on many Years of Experience.
0
<% if (session("groupName")<>"Not selected" and session("placeName") <> "Not selected") then
sql =" select distinct dr.Down_P FROM Down_rate as dr,Total_list as tl, Price_list as pl WHERE dr.ID_Down = tl.Down_ID AND tl.Model_ID=pl.ID_Model and pl.Model='"&session("groupName")&"' and pl.Sub_Model ='" & session("placeName") & "' "
elseif (session("groupName")<>"Not selected" and session("placeName")="Not selected") then
sql =" select distinct dr.Down_P FROM Down_rate as dr,Total_list as tl, Price_list as pl WHERE dr.ID_Down = tl.Down_ID AND tl.Model_ID=pl.ID_Model and pl.Model='"&session("groupName")&"' "
else
sql= "select distinct dr.Down_P FROM Down_rate as dr "
end if
rs.Open sql, conn %>