<% 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 %>
Model
BDH-6
Diameter
6"
Carbon
Steel
.006,
.008, .0104, .0118, .014
Stainless
Steel
.006SS, .0118SS,
.014SS
Arbor
Holes
1/2",
5/8"
Trim
Length
1 1/8"
Approx.
Running Face Width
1 3/8"
Max.
Safe Free Speed (RPM)
4,500
Cup
Diameter
6"
Trim Length
1 1/2"
Arbor Hole
2"
Abrasive options
80-500 AO &
SC
Max. Safe Free
Speed (RPM)
6,000
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 %>