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) - - -