Index: openacs-4/packages/survey/www/admin/responses-export-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/survey/www/admin/responses-export-oracle.xql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/survey/www/admin/responses-export-oracle.xql 26 Oct 2002 18:25:26 -0000 1.1.2.1 +++ openacs-4/packages/survey/www/admin/responses-export-oracle.xql 11 Dec 2002 19:31:42 -0000 1.1.2.2 @@ -61,7 +61,8 @@ r.creation_date, q.abstract_data_type, q.sort_order - from survey_questions q, (select initial_user_id as user_id, creation_date, response_id from survey_responses_latest rt where survey_id=:survey_id) r, cc_users u, survey_sections ss + from survey_questions q, (select initial_user_id as user_id, creation_date, response_id from survey_responses_latest rt where survey_id=:survey_id) r, (select p.email, u.first_names, u.last_name, u.person_id as user_id from parties +p, persons u where p.party_id=u.person_id) u, survey_sections ss where ss.survey_id=:survey_id and q.section_id=ss.section_id and r.user_id = u.user_id) sq Index: openacs-4/packages/survey/www/admin/responses-export-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/survey/www/admin/responses-export-postgresql.xql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/survey/www/admin/responses-export-postgresql.xql 22 Nov 2002 02:26:55 -0000 1.1.2.1 +++ openacs-4/packages/survey/www/admin/responses-export-postgresql.xql 11 Dec 2002 19:31:42 -0000 1.1.2.2 @@ -48,7 +48,8 @@ r.creation_date, q.abstract_data_type, q.sort_order - from survey_questions q, (select initial_user_id as user_id, creation_date, response_id from survey_responses_latest where survey_id=:survey_id) r, cc_users u, survey_sections ss + from survey_questions q, (select initial_user_id as user_id, creation_date, response_id from survey_responses_latest where survey_id=:survey_id) r, (select p.email, u.first_names, u.last_name, u.person_id as user_id from parties +p, persons u where p.party_id=u.person_id) u, survey_sections ss where ss.survey_id=:survey_id and q.section_id=ss.section_id and r.user_id=u.user_id) sq