Index: openacs-4/packages/assessment/tcl/as-item-data-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-item-data-procs-postgresql.xql,v diff -u -r1.2 -r1.2.2.1 --- openacs-4/packages/assessment/tcl/as-item-data-procs-postgresql.xql 12 Jun 2006 02:49:50 -0000 1.2 +++ openacs-4/packages/assessment/tcl/as-item-data-procs-postgresql.xql 8 Apr 2007 17:16:03 -0000 1.2.2.1 @@ -15,4 +15,22 @@ + + + + select d.item_data_id, d.boolean_answer, d.clob_answer, d.numeric_answer, + d.integer_answer, d.text_answer, d.timestamp_answer, d.content_answer, + d.points + from as_session_item_map m, as_item_data d + where d.session_id = :session_id + and d.subject_id = :subject_id + and d.as_item_id = :as_item_id + and m.session_id = d.session_id + and m.item_data_id = d.item_data_id + + order by d.item_data_id desc + limit 1 + + +