Index: openacs-4/packages/dotlrn/www/admin/classes-chunk.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/classes-chunk.xql,v
diff -u -r1.7 -r1.7.6.1
--- openacs-4/packages/dotlrn/www/admin/classes-chunk.xql	30 Oct 2003 17:04:40 -0000	1.7
+++ openacs-4/packages/dotlrn/www/admin/classes-chunk.xql	6 Aug 2004 02:51:24 -0000	1.7.6.1
@@ -17,9 +17,10 @@
             from dotlrn_classes_full,
                  dotlrn_departments_full
             where dotlrn_classes_full.department_key = dotlrn_departments_full.department_key
-            order by dotlrn_departments_full.pretty_name,
-                     dotlrn_classes_full.class_key,
-                     dotlrn_classes_full.pretty_name
+            order by lower(dotlrn_departments_full.pretty_name),
+                     lower(dotlrn_classes_full.pretty_name),
+                     dotlrn_classes_full.class_key
+
         </querytext>
     </fullquery>
 
@@ -39,8 +40,8 @@
                  dotlrn_departments_full
             where dotlrn_classes_full.department_key = :department_key
             and dotlrn_classes_full.department_key = dotlrn_departments_full.department_key
-            order by dotlrn_classes_full.class_key,
-                     dotlrn_classes_full.pretty_name
+            order by lower(dotlrn_classes_full.pretty_name), dotlrn_classes_full.class_key
+                     
         </querytext>
     </fullquery>