Index: openacs-4/contrib/packages/project-manager/www/process-dependency-add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/process-dependency-add-edit-postgresql.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/contrib/packages/project-manager/www/process-dependency-add-edit-postgresql.xql 10 Oct 2003 22:51:04 -0000 1.3
+++ openacs-4/contrib/packages/project-manager/www/process-dependency-add-edit-postgresql.xql 25 Jun 2004 00:04:42 -0000 1.4
@@ -10,7 +10,9 @@
FROM
pm_process_task t LEFT JOIN pm_process_task_dependency d ON t.process_task_id = d.process_task_id
WHERE
- t.process_task_id in ([join $use_dependency ", "])
+ t.process_task_id in ([join $use_dependency_list ", "])
+ ORDER BY
+ t.ordering, t.process_task_id
@@ -36,24 +38,8 @@
WHERE
process_id = :process_id
ORDER BY
- upper(one_line)
+ ordering
-
-
- DELETE FROM pm_process_task_dependency
- WHERE process_task_id = :tsk_id
-
-
-
-
-
- INSERT INTO pm_process_task_dependency
- (dependency_id, process_task_id, parent_task_id, dependency_type)
- VALUES
- (:dependency_id, :tsk_id, :parent_tsk_id, :type_id)
-
-
-