Index: openacs-4/packages/dotlrn/tcl/community-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/tcl/community-procs-oracle.xql,v diff -u -r1.9 -r1.10 --- openacs-4/packages/dotlrn/tcl/community-procs-oracle.xql 14 Feb 2002 19:43:11 -0000 1.9 +++ openacs-4/packages/dotlrn/tcl/community-procs-oracle.xql 14 Feb 2002 23:29:37 -0000 1.10 @@ -78,7 +78,7 @@ where supertype = 'dotlrn_community' start with object_type = (select community_type from dotlrn_communities - where parent_id is NULL + where parent_community_id is null and community_type != 'dotlrn_community' start with community_id = :community_id connect by community_id = prior parent_community_id)