Index: openacs-4/packages/dotlrn/www/members-chunk-table-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/members-chunk-table-oracle.xql,v
diff -u -r1.3 -r1.3.2.1
--- openacs-4/packages/dotlrn/www/members-chunk-table-oracle.xql	24 Jul 2002 14:00:39 -0000	1.3
+++ openacs-4/packages/dotlrn/www/members-chunk-table-oracle.xql	17 Oct 2002 12:52:53 -0000	1.3.2.1
@@ -15,20 +15,16 @@
             from registered_users,
                  dotlrn_member_rels_approved
             where dotlrn_member_rels_approved.community_id = :community_id
-            and dotlrn_member_rels_approved.user_id = registered_users.user_id
-            order by decode(role,
+            and dotlrn_member_rels_approved.user_id = 
+	    registered_users.user_id order by decode(role,
                             'instructor',1,
                             'admin',2,
                             'teaching_assistant',3,
                             'course_assistant',4,
                             'course_admin',5,
                             'student',6,
-                            'member',7),
-                     last_name
-            -- note, last_name should be sorted by $ order, but b/c this
-            -- query gets called by ad_table, ad_table would have to know
-            -- to uplevel order.. not going to happen.  So no reversals on 
-            -- last name for now, sorry.
+                            'member',7), $order_by
+            
         </querytext>
     </fullquery>