Index: openacs-4/contrib/packages/portal/tcl/element-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/portal/tcl/element-procs-oracle.xql,v diff -u -r1.4 -r1.5 --- openacs-4/contrib/packages/portal/tcl/element-procs-oracle.xql 27 Jan 2004 03:33:46 -0000 1.4 +++ openacs-4/contrib/packages/portal/tcl/element-procs-oracle.xql 12 Feb 2004 21:31:20 -0000 1.5 @@ -7,13 +7,14 @@ insert into portal_elements (element_id, datasource_id, name, application_id, - page_id, region, sort_key, shadeable_p, hideable_p) + page_id, region, state, sort_key, shadeable_p, hideable_p) select :element_id, :datasource_id, :name, :application_id, :page_id, :region, + :state, nvl((select max(portal_elements.sort_key) + 1 from portal_elements where page_id = :page_id