Index: openacs-4/packages/dotlrn/www/communities-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/communities-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn/www/communities-oracle.xql	8 Dec 2001 01:23:46 -0000	1.1
+++ openacs-4/packages/dotlrn/www/communities-oracle.xql	17 Dec 2001 23:02:56 -0000	1.2
@@ -10,15 +10,13 @@
              dotlrn_communities.pretty_name,
              dotlrn_communities.description,
              dotlrn_communities.package_id,
-             (select site_node.url(site_nodes.node_id)
-              from site_nodes
-              where site_nodes.object_id = dotlrn_communities.package_id) as url,
+             dotlrn_community.url(dotlrn_communities.community_id) as url,
              (select decode(count(*), 0, 'f', 't')
               from dotlrn_member_rels_full
               where dotlrn_member_rels_full.user_id = :user_id
               and dotlrn_member_rels_full.community_id = dotlrn_communities.community_id) as member_p,
              acs_permission.permission_p(:user_id, dotlrn_communities.community_id, 'admin') as admin_p
-      from dotlrn_active_not_closed_comms dotlrn_communities
+      from dotlrn_active_comms_not_closed dotlrn_communities
       where dotlrn_communities.community_type = :community_type
     </querytext>
   </fullquery>