Index: openacs-4/packages/evaluation/lib/evaluations-chunk-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/lib/Attic/evaluations-chunk-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/evaluation/lib/evaluations-chunk-oracle.xql	31 Mar 2005 11:09:27 -0000	1.1
+++ openacs-4/packages/evaluation/lib/evaluations-chunk-oracle.xql	7 Apr 2005 11:26:58 -0000	1.2
@@ -26,12 +26,13 @@
 
 <fullquery name="get_answer_info">      
       <querytext>
-	    select ea.data as answer_data, 
-	    ea.title as answer_title, 
+	    select crr.filename as answer_data, 
+	    crr.title as answer_title, 
 	    ea.answer_id 
-	    from evaluation_answersi ea, cr_items cri
+	    from evaluation_answers ea, cr_items cri, cr_revisions crr
 	    where ea.task_item_id = :task_item_id 
 	    and cri.live_revision = ea.answer_id
+		and crr.revision_id = ea.answer_id 
 	    and ea.party_id = evaluation.party_id(:user_id,:task_id)
       </querytext>
 </fullquery>