daoGetFieldSelection

Related DAO Code

        List<LookupPair> map = new ArrayList<LookupPair>();

        connect();
        useApp(application);
        field = field.replace("Multi", "");
        String sql = "select "+field+"Key, "+field+"Label from lkup_"+field+
                         " where "+field+"Order > -1 order by "+field+"Order";
        
        ResultSet rs=st.executeQuery(sql);

        while(rs.next())
        {
            map.add(new LookupPair(rs.getString(1),rs.getString(2)));
        }
        rs.close();
        disconnect();
        return map;