Index: openacs-4/packages/assessment/tcl/as-assessment-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-assessment-procs-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/assessment/tcl/as-assessment-procs-postgresql.xql 26 Nov 2004 20:48:37 -0000 1.1 +++ openacs-4/packages/assessment/tcl/as-assessment-procs-postgresql.xql 3 Dec 2004 10:24:21 -0000 1.2 @@ -5,12 +5,12 @@ - select a.assessment_id as assessment_rev_id, cr.item_id as assessment_id, cr.title, + select a.assessment_id as assessment_rev_id, cr.item_id as assessment_id, cr.title, ci.name, cr.description, o.creation_user, o.creation_date, a.instructions, a.mode, a.anonymous_p, a.secure_access_p, a.reuse_responses_p, a.show_item_name_p, a.entry_page, a.exit_page, a.consent_page, a.return_url, a.start_time, a.end_time, a.number_tries, a.wait_between_tries, - a.time_for_response, a.show_feedback, a.section_navigation, a.creator_id + a.time_for_response, a.show_feedback, a.section_navigation, a.creator_id, a.survey_p from as_assessments a, cr_revisions cr, cr_items ci, acs_objects o where ci.item_id = :assessment_id and cr.revision_id = ci.latest_revision