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 -r1.2.4.1 -r1.2.4.2
--- openacs-4/packages/survey/www/admin/view-text-responses-oracle.xql	24 Aug 2004 21:42:33 -0000	1.2.4.1
+++ openacs-4/packages/survey/www/admin/view-text-responses-oracle.xql	25 Aug 2004 17:22:02 -0000	1.2.4.2
@@ -4,11 +4,12 @@
 
 <fullquery name="all_responses_to_question">      
     <querytext>
-       select
-          $column_name as response,
+
+      select
+          $column_name as response, initial_user_id,
           person.name(initial_user_id) as respondent_name,
           o.creation_date as submission_date,
-          o.creation_user,
+          initial_user_id as creation_user,
           o.creation_ip as ip_address
         from
           survey_responses_latest r,
@@ -17,7 +18,7 @@
         where
           qr.response_id = r.response_id
           and qr.question_id = :question_id
-          and o.object_id = initial_user_id
+          and o.object_id = r.response_id
         order by submission_date
 
       </querytext>