SELECT O.OrgID, O.OrgName, O.OrgContact, O.OrgConTitle, O.OrgAddr1, O.OrgAddr2, O.OrgCity, O.OrgState, O.OrgZip, O.OrgPhone, O.OrgFax, O.OrgEmail, O.OrgSite FROM #tblOrgs# AS O INNER JOIN #tblOrgCats# AS C ON O.OrgID = C.OrgID WHERE C.CatID = #URL.cid# AND C.AHRS = true AND SiteStatus = 'ACTIVE' ORDER BY OrgName; SELECT CategoryID, ParentID, CategoryName FROM #tblCats# WHERE CategoryID = #iNextCatID#; ' & qryCatPath.CategoryName & ''> ' & qryCatPath.CategoryName & ' : ' & CatPath> Category Index : ' & CatPath> Sustainable Building Resource Directory
SELECT CSID FROM #tblCases# WHERE OrgID = #qryCatOrgs.OrgID#;
Sustainable Building Resource Directory
[View Full Directory] - [View By Category] - [Case Studies] - [Organization Search] - [Product Search] - [Logout [#thisUser#]][Login]
[Only GAH Organizations][GAH and non-GAH Organizations]
#CatPath#
ADMIN: [Add a Subcategory] - [Remove this Category]
ADMIN: [Remove this Category]
#qryCatOrgs.OrgName# Website Case Study ADMIN: [Add Case Study]
  #qryCatOrgs.OrgAddr1#
#qryCatOrgs.OrgAddr2#
 #qryCatOrgs.OrgCity#, #qryCatOrgs.OrgState# #qryCatOrgs.OrgZip#
TEL: #qryCatOrgs.OrgPhone#
FAX: #qryCatOrgs.OrgFax# 		#qryCatOrgs.OrgContact#
#qryCatOrgs.OrgConTitle#
 #qryCatOrgs.OrgEmail#
ADMIN: [Edit Details] - [DELETE #qryCatOrgs.OrgName#]
No Organizations were found in this Category.
ADMIN: [Add a Category]
SELECT CategoryID, CategoryName FROM #tblCats# WHERE ParentID = 0 ORDER BY DisplayIndex; SELECT DISTINCT OC.OrgID FROM #tblOrgCats# AS OC INNER JOIN #tblOrgs# AS O ON OC.OrgID = O.OrgID WHERE OC.CatID = #qryTier1.CategoryID# AND OC.AHRS = true AND O.SiteStatus = 'ACTIVE' ; SELECT CategoryID, CategoryName FROM #tblCats# WHERE ParentID = #qryTier1.CategoryID# ORDER BY DisplayIndex; SELECT DISTINCT OC.OrgID FROM #tblOrgCats# AS OC INNER JOIN #tblOrgs# AS O ON OC.OrgID = O.OrgID WHERE OC.CatID = #qryTier2.CategoryID# AND OC.AHRS = true AND O.SiteStatus = 'ACTIVE' ; SELECT CategoryID, CategoryName FROM #tblCats# WHERE ParentID = #qryTier2.CategoryID# ORDER BY DisplayIndex; SELECT DISTINCT OC.OrgID FROM #tblOrgCats# AS OC INNER JOIN #tblOrgs# AS O ON OC.OrgID = O.OrgID WHERE OC.CatID = #qryTier3.CategoryID# AND OC.AHRS = true AND O.SiteStatus = 'ACTIVE' ; SELECT CategoryID, CategoryName FROM #tblCats# WHERE ParentID = #qryTier3.CategoryID# ORDER BY DisplayIndex; SELECT DISTINCT OC.OrgID FROM #tblOrgCats# AS OC INNER JOIN #tblOrgs# AS O ON OC.OrgID = O.OrgID WHERE OC.CatID = #qryTier4.CategoryID# AND OC.AHRS = true AND O.SiteStatus = 'ACTIVE' ;
#qryTier1.CategoryName# (#qryTier1Orgs.RecordCount#)
#qryTier2.CategoryName# (#qryTier2Orgs.RecordCount#)
#qryTier3.CategoryName# (#qryTier3Orgs.RecordCount#)
#qryTier4.CategoryName# (#qryTier4Orgs.RecordCount#)
 
 

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.