Index: openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-one-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql	4 Aug 2003 21:24:06 -0000	1.3
+++ openacs-4/contrib/packages/project-manager/www/task-one-postgresql.xql	4 Aug 2003 22:40:21 -0000	1.4
@@ -1,5 +1,28 @@
 <?xml version="1.0"?>
 <queryset>
+  <fullquery name="get_task_id">
+    <querytext>
+	SELECT
+        t.item_id
+	FROM
+	pm_tasks_revisionsx t
+	WHERE
+        t.revision_id = :task_revision_id
+    </querytext>
+  </fullquery>
+
+  <fullquery name="get_project_ids">
+    <querytext>
+	SELECT
+        t.parent_id as project_item_id
+	FROM
+	pm_tasks_revisionsx t, cr_items i
+	WHERE
+        i.item_id = t.item_id and
+        t.item_id = :task_id
+    </querytext>
+  </fullquery>
+
   <fullquery name="task_query">
     <querytext>
 	SELECT