var catCom = server.CommonSpot.api.getObject('Categories'); var catQry = catCom.getList(type="Document"); SELECT NAME FROM catQry WHERE id = if ( catQry.recordCount ) return catQry.NAME; else return ""; SELECT CategoryTypeID FROM generalCategories WHERE category = if ( catQry.recordCount ) return catQry.categoryTypeID; else return ""; var q = QueryNew("temp"); var rStr = ""; select ShortDesc from AvailableTemplates Where PageID = if ( q.recordcount ) rStr = q.ShortDesc; return rStr; select id, groupname from idgroup