Index: openacs-4/packages/survey/www/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/survey/www/index-oracle.xql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/survey/www/index-oracle.xql 9 Oct 2002 16:59:18 -0000 1.1.2.1 +++ openacs-4/packages/survey/www/index-oracle.xql 23 Oct 2002 19:44:13 -0000 1.1.2.2 @@ -6,7 +6,7 @@ select s.survey_id, s.name, s.editable_p, s.single_response_p, - sr.response_id, sr.creation_date + sr.response_id, to_char(sr.creation_date,'Month FMDD, YYYY') as creation_date from surveys s ,(select survey_id, response_id, creation_date from survey_responses_latest where initial_user_id = :user_id) sr Index: openacs-4/packages/survey/www/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/survey/www/index-postgresql.xql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/survey/www/index-postgresql.xql 9 Oct 2002 16:59:18 -0000 1.1.2.1 +++ openacs-4/packages/survey/www/index-postgresql.xql 23 Oct 2002 19:44:13 -0000 1.1.2.2 @@ -7,7 +7,7 @@ select s.survey_id, s.name, s.editable_p, s.single_response_p, - sr.response_id, sr.creation_date + sr.response_id, to_char(sr.creation_date, 'Month FMDD, YYYY') as creation_date from surveys s left outer join (select survey_id, response_id, creation_date from survey_responses_latest