Index: openacs-4/packages/acs-content-repository/sql/oracle/content-folder.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-folder.sql,v diff -u -r1.18.2.2 -r1.18.2.3 --- openacs-4/packages/acs-content-repository/sql/oracle/content-folder.sql 30 Nov 2005 01:27:45 -0000 1.18.2.2 +++ openacs-4/packages/acs-content-repository/sql/oracle/content-folder.sql 29 Dec 2005 01:24:01 -0000 1.18.2.3 @@ -38,8 +38,8 @@ v_context_id := content_folder.new.context_id; end if; - -- parent_id = 0 means that this is a mount point - if parent_id ^= 0 and + -- parent_id = security context root means that this is a mount point + if parent_id ^= 4 and content_folder.is_folder(parent_id) = 'f' and content_folder.is_registered(parent_id,'content_folder') = 'f' then @@ -49,7 +49,7 @@ v_package_id := package_id; - if parent_id is not null and parent_id ^= 0 and package_id is null then + if parent_id is not null and parent_id ^= -4 and package_id is null then v_package_id := acs_object.package_id(content_item.get_root_folder(parent_id)); end if; @@ -434,7 +434,7 @@ start with item_id = target_folder_id; - v_parent_id integer := 0; + v_parent_id integer := -4; v_sub_folder_p char := 'f'; begin