Index: openacs-4/packages/evaluation/lib/tasks-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/lib/Attic/tasks-chunk-postgresql.xql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/evaluation/lib/tasks-chunk-postgresql.xql	5 Aug 2004 23:39:11 -0000	1.9
+++ openacs-4/packages/evaluation/lib/tasks-chunk-postgresql.xql	12 Aug 2004 17:46:41 -0000	1.10
@@ -40,7 +40,8 @@
 		cr.title as task_title,
 		et.data as task_data,
 	   	et.task_id as revision_id,
-		cr.content_length,
+		coalesce(cr.content_length,0) as content_length,
+		et.late_submit_p,
 		ea.answer_id as answer_id
 	from cr_revisions cr, 
 		 evaluation_tasksi et left outer join evaluation_answersi ea on (ea.task_item_id = et.task_item_id and content_revision__is_live(ea.answer_id) = true
@@ -53,6 +54,14 @@
       </querytext>
 </fullquery>
 
+<fullquery name="compare_due_date">      
+      <querytext>
+
+	select 1 from dual where :due_date > now()
+	
+      </querytext>
+</fullquery>
+
 <fullquery name="get_group_id">      
       <querytext>