Kiosks

Kiosks are on-line profiles of organizations and individuals working toward the conservation of coral reefs around the world. Kiosks provide information about an organization's activities and resources, and offer direct links to their web sites. Kiosk Application Form. SELECT k.UID As KioskID, k.KioskName, k.OrgURL, k.OrgType, k.OrgName, k.Status, k.SecLevel, o.OrgType_Label FROM Kiosks k, OrgType_L o WHERE k.Status = 1 AND k.SecLevel <= #SecLevel# AND k.OrgType is not NULL AND O.CID = k.OrgType ORDER BY k.Created_date DESC

Last Kiosk created: #OrgName# -- #KioskName#

SELECT k.UID As KioskID, k.KioskName, k.OrgURL, k.OrgType, k.OrgName, k.Status, k.SecLevel, o.OrgType_Label FROM Kiosks k, OrgType_L o WHERE k.Status = 1 AND k.SecLevel <= #SecLevel# AND k.OrgType is not NULL AND O.CID = k.OrgType ORDER BY k.OrgType, k.OrgName, k.KioskName

#Trim(OrgType_Label)#

#OrgName# -- #KioskName#