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.8.2.5 -r1.8.2.6
--- openacs-4/packages/acs-content-repository/sql/oracle/content-folder.sql	26 May 2004 18:50:31 -0000	1.8.2.5
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-folder.sql	24 Aug 2004 23:28:39 -0000	1.8.2.6
@@ -425,14 +425,15 @@
   open c_tree_cur;
   while v_parent_id <> folder_id loop
     fetch c_tree_cur into v_parent_id;
+
+    if v_parent_id = folder_id then
+        v_sub_folder_p := 't';
+    end if;
+
     exit when c_tree_cur%NOTFOUND;
   end loop;
   close c_tree_cur;
 
-  if v_parent_id ^= 0 then 
-    v_sub_folder_p := 't';
-  end if;
-
   return v_sub_folder_p;
 
 end is_sub_folder;
