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 -N -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 @@
       </querytext>
   </fullquery>
 
+  <fullquery name="as::item_data::get.response">
+      <querytext>
+
+	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
+      </querytext>
+  </fullquery>
+  
 </queryset>