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.5 -r1.6
--- openacs-4/packages/evaluation/www/task-view-postgresql.xql	7 Jul 2004 17:26:44 -0000	1.5
+++ openacs-4/packages/evaluation/www/task-view-postgresql.xql	30 Jul 2004 22:50:09 -0000	1.6
@@ -18,9 +18,10 @@
                eg.grade_plural_name, eg.weight as grade_weight,
 	       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) 
+	evaluation_tasksi et left outer join evaluation_tasks_solsi ets on (ets.task_item_id = et.task_item_id and content_revision__is_live(ets.solution_id) = true) 
         where et.task_id = :task_id
-          and et.grade_id = eg.grade_id
+          and et.grade_item_id = eg.grade_item_id
+	  and content_revision__is_live(eg.grade_id) = true
 	
       </querytext>
 </fullquery>