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.2 -r1.3
--- openacs-4/packages/static-pages/tcl/static-pages-procs-oracle.xql 6 May 2001 19:54:35 -0000 1.2
+++ openacs-4/packages/static-pages/tcl/static-pages-procs-oracle.xql 4 Aug 2001 02:58:41 -0000 1.3
@@ -99,7 +99,23 @@
+
+
+ update static_pages set show_comments_p = :show_full_comments_p
+ where static_page_id in (
+ select static_page_id from static_pages
+ where folder_id in (
+ select folder_id from sp_folders
+ start with folder_id = :root_folder_id
+ connect by parent_id = prior folder_id)
+ and filename like '%${contained_string}%'
+ )
+
+
+
+
+
@@ -123,5 +139,17 @@
+
+
+ select static_page_id from static_pages
+ where folder_id in (
+ select folder_id from sp_folders
+ start with folder_id = :root_folder_id
+ connect by parent_id = prior folder_id)
+ and filename like '%${contained_string}%'
+
+
+
+