Index: openacs-4/packages/assessment/tcl/as-item-form-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-item-form-procs.xql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/assessment/tcl/as-item-form-procs.xql 9 Apr 2005 22:39:27 -0000 1.7 +++ openacs-4/packages/assessment/tcl/as-item-form-procs.xql 13 Apr 2005 18:51:54 -0000 1.8 @@ -1,23 +1,4 @@ - - - select cr.title, i.subtext, i.data_type, - max(oi.object_id) as item_type_id, oi.object_type as item_type, - od.object_id as display_type_id, od.object_type as display_type - from as_items i, cr_revisions cr, as_item_rels it, - as_item_rels dt, acs_objects oi, acs_objects od - where i.as_item_id = :item_id - and cr.revision_id = i.as_item_id - and it.item_rev_id = i.as_item_id - and dt.item_rev_id = i.as_item_id - and it.rel_type = 'as_item_type_rel' - and dt.rel_type = 'as_item_display_rel' - and oi.object_id = it.target_rev_id - and od.object_id = dt.target_rev_id - group by cr.title, i.subtext, i.data_type, oi.object_type,od.object_id, od.object_type - - -