Index: openacs-4/packages/dotlrn-assessment/tcl/dotlrn-assessment-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-assessment/tcl/dotlrn-assessment-procs.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn-assessment/tcl/dotlrn-assessment-procs.xql	27 Jun 2005 21:02:25 -0000	1.1.2.1
@@ -0,0 +1,19 @@
+<?Xml version="1.0"?>
+
+<queryset>
+<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="dotlrn_assessment::clone.get_assessments">
+  <querytext>
+	select ci.item_id as assessment_id, cr.title
+	from cr_folders cf, cr_items ci, cr_revisions cr, as_assessments a
+        where cr.revision_id = ci.latest_revision
+        and a.assessment_id = cr.revision_id
+        and ci.parent_id = cf.folder_id and cf.package_id = :old_package_id
+        order by cr.title
+  </querytext>
+</fullquery>
+
+
+</queryset>
+