Index: openacs-4/packages/workflow/tcl/role-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/role-procs.xql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/workflow/tcl/role-procs.xql 5 Mar 2003 17:18:10 -0000 1.7 +++ openacs-4/packages/workflow/tcl/role-procs.xql 1 Dec 2003 09:53:19 -0000 1.8 @@ -1,24 +1,6 @@ - - - select count(*) - from workflow_roles - where workflow_id = :workflow_id - and sort_order = :sort_order - - - - - - update workflow_roles - set sort_order = sort_order + 1 - where workflow_id = :workflow_id - and sort_order >= :sort_order - - - insert into workflow_roles @@ -78,6 +60,22 @@ + + + select count(*) + from workflow_roles + where workflow_id = :workflow_id + and sort_order = :sort_order + + + + + update workflow_roles + set sort_order = sort_order + 1 + where workflow_id = :workflow_id + and sort_order >= :sort_order + +