Index: openacs-4/packages/dotlrn/dotlrn.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/dotlrn.info,v
diff -u -r1.71 -r1.72
--- openacs-4/packages/dotlrn/dotlrn.info	7 Apr 2002 04:19:07 -0000	1.71
+++ openacs-4/packages/dotlrn/dotlrn.info	8 Apr 2002 13:26:16 -0000	1.72
@@ -198,9 +198,9 @@
             <file type="query_file" db_type="oracle" path="www/admin/club-oracle.xql"/>
             <file type="content_page" path="www/admin/club.adp"/>
             <file type="content_page" path="www/admin/club.tcl"/>
-            <file type="query_file" db_type="oracle" path="www/admin/clubs-oracle.xql"/>
             <file type="content_page" path="www/admin/clubs.adp"/>
             <file type="content_page" path="www/admin/clubs.tcl"/>
+            <file type="query_file" path="www/admin/clubs.xql"/>
             <file type="content_page" path="www/admin/department-edit.adp"/>
             <file type="content_page" path="www/admin/department-edit.tcl"/>
             <file type="query_file" path="www/admin/department-edit.xql"/>
Fisheye: Tag 1.4 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn/www/admin/clubs-oracle.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn/www/admin/clubs.xql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/dotlrn/www/admin/users-add-to-community.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/users-add-to-community.tcl,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/dotlrn/www/admin/users-add-to-community.tcl	29 Mar 2002 19:14:47 -0000	1.4
+++ openacs-4/packages/dotlrn/www/admin/users-add-to-community.tcl	8 Apr 2002 13:26:16 -0000	1.5
@@ -46,8 +46,11 @@
         -value $referer
 
 set communities [db_list_of_lists select_all_communities {
-    select pretty_name, community_id
+    select dotlrn_communities.pretty_name,
+           dotlrn_communities.community_id
     from dotlrn_communities
+    order by dotlrn_communities.pretty_name,
+             dotlrn_communities.community_id
 }]
 
 if {[llength $communities]} {