.append(scope.getFocusItemID())
.append(scope.getFocusItemId())
    protected static String getItemValue(BrowseScope scope)        throws SQLException    {        if (! scope.focusIsItem())            return null;        PreparedStatement statement = null;        ResultSet results = null;        try        {            String tablename = BrowseTables.getTable(scope);            String column = BrowseTables.getValueColumn(scope);            String itemValueQuery = new StringBuffer()                .append("select ")                .append("max(")                .append(column)                .append(") from ")                .append(tablename)                .append(" where ")                .append(" item_id = ")                .append(scope.getFocusItemID())                .append(getScopeClause(scope, "and"))                .toString();            statement = createStatement(scope, itemValueQuery);            results = statement.executeQuery();            String itemValue = results.next() ? results.getString(1) : null;            if (log.isDebugEnabled())                log.debug("Subquery value is " + itemValue);            return itemValue;        }        finally        {            if (statement != null)                statement.close();            if (results != null)                results.close();        }    }