Metacat

   * @param unaccessableNodePair  the node pair(start id and end id) which this

   *                               user could not access it

  public String printExtendedSQL(String doclist, Hashtable unaccessableNodePair)

    // add control part for extended query

    Enumeration en = unaccessableNodePair.keys();

    while (en.hasMoreElements())

    {

      // Get control pairs in object

      Long startNodeIdObject = (Long)en.nextElement();

      Long endNodeIdObject = (Long)unaccessableNodePair.get(startNodeIdObject);

      // change it to long

      long startNodeId = startNodeIdObject.longValue();

      long endNodeId   = endNodeIdObject.longValue();

      // add into query

      self.append(" AND( nodeid < ");

      self.append(startNodeId);

      self.append(" OR nodeid > ");

      self.append(endNodeId);

      self.append(")");

    }