Sennheiser Products

<% path="../admin/" if request("pid") <> "" then strSQL="Select * from product where productID='"&safeSQL(request("pid"))&"'" else strSQL="select * from product,productCategory,productSubCategory " strSQL=strSQL+"where " strSQL=strSQL+"productSubCategory.groupid=productCategory.groupid and " strSQL=strSQL+"product.subgroupid=productSubCategory.subgroupid " strSQL=strSQL+"and product.subgroupid = '"&safeSQL(request("sid"))&"'" end if set rsProduct=db.execute(strSQL) if not rsProduct.eof then %>

" width="380" height="330">

Sennheiser Product

<% set subcategory=db.execute("select * from productSubCategory where subgroupid='"&request("sid")&"'") if not subcategory.eof then response.write(subcategory("name")) end if set subcatCount=db.execute("select count(*) as count from product where subgroupid='"&request("sid")&"'") if not subcatCount.eof then count=subcatCount("count") end if %>

<%if rsProduct("description") <> "" then%> <%end if%> <%if rsProduct("features") <> "" then%> <%end if%> <%if rsProduct("otherProducts") <> "" then%> <%end if%> <%end if%>

	<%=rsProduct("modelNo")%>

	General Description
	<%=rsProduct("description")%>

	Features
	<%=rsProduct("features")%>

	Other Products
	<%=rsProduct("otherProducts")%>

<%if (count > 7) then%>

<%end if%>

<%if (count > 7) then%>

<%end if%>