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.14 -r1.15
--- openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql	26 Feb 2004 15:15:41 -0000	1.14
+++ openacs-4/contrib/packages/project-manager/www/task-add-edit-postgresql.xql	12 Mar 2004 13:44:45 -0000	1.15
@@ -9,7 +9,8 @@
         t.estimated_hours_work,
         t.estimated_hours_work_min,
         t.estimated_hours_work_max,
-        d.dependency_id
+        d.dependency_id,
+        d.parent_task_id as process_parent_task
         FROM
         pm_process_task t LEFT JOIN pm_process_task_dependency d ON t.process_task_id = d.process_task_id
         WHERE
@@ -26,7 +27,7 @@
                 :project_item_id,
                 :p_task_title,
                 :p_description,
-                [project_manager::project::util::datenvl -value [set end_date_$i] -value_if_null "null," -value_if_not_null "to_timestamp('[set end_date_$i]','YYYY MM DD HH24 MI SS'),"]
+                [pm::util::datenvl -value [set end_date_$i] -value_if_null "null," -value_if_not_null "to_timestamp('[set end_date_$i]','YYYY MM DD HH24 MI SS'),"]
                 :p_percent,
                 :p_work,
                 :p_work_min,
@@ -44,26 +45,22 @@
     <querytext>
       select
         current_timestamp
-        FROM
-        dual
     </querytext>
   </fullquery>
 
   <fullquery name="get_old_tasks">
     <querytext>
         select
         t.task_revision_id,
-        t.title as task_title,
-        t.item_id,
-        t.description,
-        t.name,
-        to_char(t.end_date,'YYYY MM DD') as end_date,
-        t.percent_complete,
-        t.estimated_hours_work,
-        t.estimated_hours_work_min,
-        t.estimated_hours_work_max,
-        d.parent_task_id,
-        t.actual_hours_worked
+        t.title as my_task_title,
+        t.description as my_description,
+        to_char(t.end_date,'YYYY MM DD') as my_end_date,
+        t.percent_complete as my_percent_complete,
+        t.estimated_hours_work as my_estimated_work,
+        t.estimated_hours_work_min as my_estimated_work_min,
+        t.estimated_hours_work_max as my_estimated_work_max,
+        t.actual_hours_worked as my_actual_hours_worked,
+        d.parent_task_id as my_dependency
         FROM
         pm_tasks_revisionsx t, 
         cr_items i LEFT JOIN pm_task_dependency d ON i.item_id = d.task_id
@@ -113,15 +110,6 @@
     </querytext>
   </fullquery>
 
-  <fullquery name="new_dependency">
-    <querytext>
-        INSERT INTO pm_task_dependency
-        (dependency_id, task_id, parent_task_id, dependency_type) 
-        VALUES
-        (:dependency_id, :this_task_id, :parent_task_id, :p_dep_type)
-    </querytext>
-  </fullquery>
-
   <fullquery name="get_task_item_id">
     <querytext>
       select