<% 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 %>
Solid
End Brush: General purpose end brushes
used for cleaning castings, blending,
polishing dies and removing carbon
deposits on piston heads, cylinders
and valve seats.
Available with Nylon, or Brass Fill
Material.
Cup
Diameter
1/2"
Trim Length
7/8"
Shank Diameter
1/4"
Stock Abrasive
180
AO
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 %>
