Index: openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-add-edit-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql	30 Jul 2003 23:36:08 -0000	1.2
+++ openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql	31 Jul 2003 20:11:41 -0000	1.3
@@ -39,19 +39,20 @@
   <fullquery name="task_query">
     <querytext>
       select
-        task_revision_id,
-        title as task_title,
-        item_id,
-        description,
-        name,
-        parent_id,
-	to_char(start_date,'YYYY MM DD') as start_date,
-	to_char(end_date,'YYYY MM DD') as end_date,
-        percent_complete
+        t.task_revision_id,
+        t.title as task_title,
+        t.item_id,
+        t.description,
+        t.name,
+        t.parent_id,
+	to_char(t.start_date,'YYYY MM DD') as start_date,
+	to_char(t.end_date,'YYYY MM DD') as end_date,
+        t.percent_complete
 	FROM
-	pm_tasks_revisionsx
+	pm_tasks_revisionsx t, cr_items i
         WHERE
-        item_id = :task_id
+        t.item_id = :task_id and
+        t.revision_id = i.live_revision
     </querytext>
   </fullquery>
 </queryset>