SELECT ProdCatID, ProdCatName FROM #tblProdCats# ORDER BY ProdCatName; SELECT P.*, O.OrgName FROM #tblOrgProds# AS P INNER JOIN #tblOrgs# AS O ON P.OrgID = O.OrgID WHERE P.ProdCatID = #URL.cid# AND O.SiteStatus = 'ACTIVE' ORDER BY P.ProdName; Sustainable Building Resource Directory
Sustainable Building Resource Directory
[View Full Directory] - [View By Category] - [Case Studies] - [Organization Search] - [Product Search] - [Logout [#thisUser#]][Login]
Product Categories
SELECT COUNT(ProdID) AS ProdCount FROM #tblOrgProds# WHERE ProdCatID = #qryAllProdCats.ProdCatID#;
#qryAllProdCats.ProdCatName# (#qryProds.ProdCount#)
No Product Categories were found in the database.
#qryProdList.ProdName#
#qryProdList.ProdManu#
#qryProdList.ProdBrand#		 Manufacture
 Distribute
 Install
 Repair / Service
 Sales / Wholesale
 Sales / Retail
 Other: #qryProdList.OtherText# Other
ADMIN: [Edit #qryProdList.OrgName# Products]
Product of #qryProdList.OrgName#
No Products were found within the specified Product Category.
 
 

Virginia Sustainable Building Network The Sustainable Building Resource Directory website is sponsored by the Virginia Sustainable Building Network, an organization that brings together representatives from diverse sectors who are interested in building healthy, environmentally friendly buildings and sustainable communities. Disclaimer.

Copyright © 2005 Virginia Sustainable Building Network.