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.2 -r1.3 --- openacs-4/packages/dotlrn/www/members-chunk-table-oracle.xql 23 Jul 2002 13:40:45 -0000 1.2 +++ openacs-4/packages/dotlrn/www/members-chunk-table-oracle.xql 24 Jul 2002 14:00:39 -0000 1.3 @@ -16,9 +16,16 @@ 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,'instructor',1,'admin',2,'teaching_assistant',3,'course_assistant',4,'course_admin',5,'student',6,'member',7) + 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 + -- 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.