Index: openacs-4/packages/dotlrn/tcl/community-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/tcl/community-procs.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn/tcl/community-procs.xql 8 Oct 2001 21:39:05 -0000 1.1
+++ openacs-4/packages/dotlrn/tcl/community-procs.xql 9 Oct 2001 14:35:58 -0000 1.2
@@ -35,7 +35,7 @@
-select rel_id, users.user_id, first_names, last_name, email from users, dotlrn_community_memberships
+select rel_id, users.user_id, first_names, last_name, email from registered_users users, dotlrn_community_memberships
where community_id= :community_id and users.user_id = dotlrn_community_memberships.user_id
@@ -55,9 +55,9 @@
-
+
-select rel_id from dotlrn_community_memberships where community_id= :community_id and user_id= :user_id
+select rel_id, page_id from dotlrn_community_memberships where community_id= :community_id and user_id= :user_id