Index: openacs-4/packages/evaluation/www/task-view-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/task-view-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/evaluation/www/task-view-postgresql.xql	7 Jun 2004 16:05:07 -0000	1.3
+++ openacs-4/packages/evaluation/www/task-view-postgresql.xql	15 Jun 2004 23:20:29 -0000	1.4
@@ -12,16 +12,28 @@
                et.description,
                et.title as task_title,
                et.data as task_data,
+	       et.revision_id as task_revision_id,
                ets.title as solution_title,
                ets.data as solution_data,
                eg.grade_plural_name, eg.weight as grade_weight,
-	       ets.revision_id
-        from evaluation_grades eg, evaluation_tasksi et 
-               left outer join evaluation_tasks_solsi ets on (ets.task_id = et.task_id and content_revision__is_live(ets.solution_id) = true) 
+	       ets.revision_id as solution_revision_id
+        from evaluation_grades eg,
+	evaluation_tasksi et left outer join evaluation_tasks_solsi ets on (ets.task_id = et.task_id and content_revision__is_live(ets.solution_id) = true) 
         where et.task_id = :task_id
           and et.grade_id = eg.grade_id
 	
       </querytext>
 </fullquery>
 
+<fullquery name="task_info">      
+      <querytext>
+
+		select et.task_name, et.description, to_char(et.due_date,'YYYY-MM-DD HH24:MI:SS') as due_date_ansi, 
+		       et.weight, et.number_of_members, et.online_p, et.late_submit_p, et.requires_grade_p
+		from evaluation_tasksi et
+		where task_id = :task_id
+	
+      </querytext>
+</fullquery>
+
 </queryset>