Index: openacs-4/packages/attendance/lib/cp-attendance-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attendance/lib/cp-attendance-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/attendance/lib/cp-attendance-oracle.xql	16 Jul 2005 13:06:32 -0000	1.1
+++ openacs-4/packages/attendance/lib/cp-attendance-oracle.xql	4 Apr 2006 01:28:44 -0000	1.2
@@ -38,6 +38,7 @@
 			and grade_item_id = :grade_item_id
 			and cri.live_revision = et.task_id
 			and et.mime_type = crmt.mime_type
+	                order by due_date asc
 		</querytext>
 	</fullquery>
 
Index: openacs-4/packages/attendance/lib/cp-attendance-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/attendance/lib/cp-attendance-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/attendance/lib/cp-attendance-postgresql.xql	16 Jul 2005 13:06:32 -0000	1.1
+++ openacs-4/packages/attendance/lib/cp-attendance-postgresql.xql	4 Apr 2006 01:28:44 -0000	1.2
@@ -34,7 +34,8 @@
 			where cr.revision_id = et.revision_id
 			and grade_item_id = :grade_item_id
 			and cri.live_revision = et.task_id
-			and et.mime_type = crmt.mime_type
+			and et.mimre_type = crmt.mime_type
+			order by due_date asc
 		</querytext>
 	</fullquery>