Index: openacs-4/packages/assessment/tcl/as-section-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-section-procs-postgresql.xql,v diff -u -N -r1.8 -r1.9 --- openacs-4/packages/assessment/tcl/as-section-procs-postgresql.xql 4 Aug 2006 19:06:03 -0000 1.8 +++ openacs-4/packages/assessment/tcl/as-section-procs-postgresql.xql 7 Aug 2006 01:19:34 -0000 1.9 @@ -5,11 +5,12 @@ - select s.as_item_id, ci.name, r.title, r.content as - question_text, r.description, i.subtext, m.required_p, + select s.as_item_id, ci.name, r.title, + r.description, i.subtext, m.required_p, m.max_time_to_complete, r2.revision_id as content_rev_id, r2.title as content_filename, ci2.content_type, - ir.target_rev_id as as_item_type_id, i.validate_block + ir.target_rev_id as as_item_type_id, i.validate_block, + r.content as question_text from cr_items ci, as_items i, as_item_section_map m, cr_revisions r, as_item_rels ir, as_session_items s left outer join as_item_rels ar on (ar.item_rev_id = s.as_item_id and ar.rel_type = 'as_item_content_rel') @@ -32,10 +33,11 @@ - select i.as_item_id, ci.name, cr.content as question_text, cr.title, cr.description, i.subtext, + select i.as_item_id, ci.name, cr.title, cr.description, i.subtext, m.required_p, m.max_time_to_complete, r2.revision_id as content_rev_id, r2.title as content_filename, ci2.content_type, m.fixed_position, - ir.target_rev_id as as_item_type_id, i.validate_block + ir.target_rev_id as as_item_type_id, i.validate_block, + cr.content as question_text from as_item_section_map m, cr_revisions cr, cr_items ci, as_item_rels ir, as_items i left outer join as_item_rels ar on (ar.item_rev_id = i.as_item_id and ar.rel_type = 'as_item_content_rel')