Index: openacs-4/packages/survey/www/admin/view-text-responses-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/survey/www/admin/view-text-responses-oracle.xql,v
diff -u -N -r1.2 -r1.2.4.1
--- openacs-4/packages/survey/www/admin/view-text-responses-oracle.xql	23 Nov 2002 05:18:16 -0000	1.2
+++ openacs-4/packages/survey/www/admin/view-text-responses-oracle.xql	24 Aug 2004 21:42:33 -0000	1.2.4.1
@@ -4,21 +4,22 @@
 
 <fullquery name="all_responses_to_question">      
     <querytext>
-	select
-	  $column_name as response,
-	  person.name(o.creation_user) as respondent_name,
-	  o.creation_date as submission_date,
-	  o.creation_user,
-	  o.creation_ip as ip_address
-	from
-	  survey_responses r,
-	  survey_question_responses qr,
-	  acs_objects o
-	where
-	  qr.response_id = r.response_id
-	  and qr.question_id = :question_id
-	  and o.object_id = qr.response_id
-	order by submission_date
+       select
+          $column_name as response,
+          person.name(initial_user_id) as respondent_name,
+          o.creation_date as submission_date,
+          o.creation_user,
+          o.creation_ip as ip_address
+        from
+          survey_responses_latest r,
+          survey_question_responses qr,
+          acs_objects o
+        where
+          qr.response_id = r.response_id
+          and qr.question_id = :question_id
+          and o.object_id = initial_user_id
+        order by submission_date
+
       </querytext>
 </fullquery>