Index: openacs-4/contrib/packages/project-manager/www/process-task-add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/process-task-add-edit-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/packages/project-manager/www/process-task-add-edit-postgresql.xql	3 Oct 2003 22:21:45 -0000	1.2
+++ openacs-4/contrib/packages/project-manager/www/process-task-add-edit-postgresql.xql	7 Oct 2003 00:15:09 -0000	1.3
@@ -1,55 +1,23 @@
 <?xml version="1.0"?>
 <queryset>
-  <fullquery name="edit_task">
-    <querytext>
-        update
-        pm_process_task 
-        set 
-        process_task_id          = :process_task_id,
-        process_id               = :process_id,
-        one_line                 = :one_line,
-        description              = :desc,
-        estimated_hours_work     = :work,
-        estimated_hours_work_min = :work_min,
-        estimated_hours_work_max = :work_max
-    </querytext>
-  </fullquery>
 
-  <fullquery name="task_query">
+  <fullquery name="get_process_tasks">
     <querytext>
-      select
-        current_timestamp
+	SELECT
+        process_task_id,
+        one_line,
+        description,
+        estimated_hours_work,
+        estimated_hours_work_min,
+        estimated_hours_work_max
 	FROM
-	dual
-    </querytext>
-  </fullquery>
-
-  <fullquery name="get_old_tasks">
-    <querytext>
-        select
-        t.process_id,
-        t.one_line as task_title,
-        t.description,
-        t.estimated_hours_work,
-        t.estimated_hours_work_min,
-        t.estimated_hours_work_max
-  	FROM
-	pm_process_task t LEFT JOIN pm_process_task_dependency d ON d.process_task_id = t.process_task_id
+        pm_process_task
         WHERE
-        t.process_task_id in ([join $process_task_id ","])
+        process_task_id in ([join $process_task_id ", "])
+        ORDER BY
+        process_task_id
     </querytext>
   </fullquery>
 
-  <fullquery name="get_project_id">
-    <querytext>
-        SELECT
-        p.project_id
-        FROM
-        pm_projectsx p, cr_items i
-        WHERE
-        p.item_id = :project_item_id and 
-        p.revision_id = i.live_revision
-    </querytext>
-  </fullquery>
 
 </queryset>