%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% dim xVehicle, xYear, ptsNo if request.querystring("vh") = "" then xVehicle = 302 else xVehicle = request.querystring("vh") end if if request.querystring("yr") = "" then xYear = "2005-2008" else xYear = request.querystring("yr") end if if request.querystring("pts") = "" then ptsNo = 36810 else ptsNo = request.querystring("pts") end if xYear = split(xYear, "-") qryPart = "select * from tblParts inner join tblVehicles on tblParts.pVehicle = tblVehicles.vNo inner join tblPartsTypesSub on tblParts.pTypeSub = tblPartsTypesSub.ptsNo " & _ "inner join tblManufacturer on tblParts.pMan = tblManufacturer.manNo where pTypeSub = " & ptsNo & " and " & xYear(0) & " >= pMin and " & xYear(1) & " <= pMax and pVehicle = " & xVehicle & " order by pName" set rsPart = oConn.execute(qryPart) %>
DESCRIPTION: <%=rsPart("pDesc")%>
TO ORDER: Call 239-225-7529