Index: openacs-4/packages/assessment/www/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/index-oracle.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/assessment/www/index-oracle.xql 18 Apr 2005 12:30:27 -0000 1.3 +++ openacs-4/packages/assessment/www/index-oracle.xql 22 Apr 2005 15:16:52 -0000 1.4 @@ -17,6 +17,7 @@ where asm.assessment_id = a.assessment_id and ism.section_id = asm.section_id) and acs_permission.permission_p (a.assessment_id, :user_id, 'read') = 't' + order by lower(cr.title) Index: openacs-4/packages/assessment/www/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/index-postgresql.xql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/assessment/www/index-postgresql.xql 18 Apr 2005 12:30:27 -0000 1.4 +++ openacs-4/packages/assessment/www/index-postgresql.xql 22 Apr 2005 15:16:52 -0000 1.5 @@ -17,6 +17,7 @@ where asm.assessment_id = a.assessment_id and ism.section_id = asm.section_id) and acs_permission__permission_p (a.assessment_id, :user_id, 'read') = 't' + order by lower(cr.title) Index: openacs-4/packages/assessment/www/index.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/index.xql,v diff -u -r1.8 -r1.9 --- openacs-4/packages/assessment/www/index.xql 18 Apr 2005 12:30:27 -0000 1.8 +++ openacs-4/packages/assessment/www/index.xql 22 Apr 2005 15:16:52 -0000 1.9 @@ -13,6 +13,7 @@ where s.assessment_id = a.assessment_id and s.subject_id = :user_id and s.completed_datetime is not null) + order by lower(cr.title)