Index: openacs-4/packages/static-pages/tcl/static-pages-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/tcl/static-pages-procs-oracle.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/static-pages/tcl/static-pages-procs-oracle.xql	3 Dec 2001 16:58:46 -0000	1.7
+++ openacs-4/packages/static-pages/tcl/static-pages-procs-oracle.xql	13 Aug 2002 12:33:53 -0000	1.8
@@ -101,7 +101,7 @@
 <fullquery name="sp_sync_cr_with_filesystem.get_folder_id">
       <querytext>
 
-        select nvl(content_item.get_id(:cumulative_path,:root_folder_id),0)
+        select nvl((select item_id from cr_items where name=:cumulative_path),0)
         from dual
 
       </querytext>