%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
qryTypes = "select ptNo, ptName from tblPartsTypes order by ptName"
set rsTypes = oConn.execute(qryTypes)
dim xType
xType = ""
while not rsTypes.eof
xType = xType & rsTypes("ptNo") & "," & rsTypes("ptName") & "\\"
rsTypes.movenext
wend
rsTypes.close
set rsTypes = nothing
xType = split(xType, "\\") ' make the array
qryMan = "select manNo, manName, manLink from tblManufacturer order by manName"
set rsMan = oConn.execute(qryMan)
%>
Mustang Motorsports - Sitemap
Mustang Motorsports Sitemap
Parts
<% for i = 0 to ubound(xType) - 1
yType = split(xType(i), ",")
%>
<%=yType(1)%>
<% qryTypes = "select ptsNo, ptsName, ptsMain from tblPartsTypesSub where ptsMain = " & yType(0)
set rsTypes = oConn.execute(qryTypes)
while not rsTypes.eof %>
" class="sitemap"><%=rsTypes("ptsName")%> |
<% rsTypes.movenext
wend
next %>