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 @@
       </querytext>
 </fullquery>
 
+<fullquery name="sp_change_matching_display.show_or_summarize_comments_matching">
+      <querytext>
 
+	    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}%'
+	        )
+
+      </querytext>
+</fullquery>
+
+
 <fullquery name="sp_change_matching_permissions.grant_or_revoke_matching_permissions">
       <querytext>
 
@@ -123,5 +139,17 @@
       </querytext>
 </fullquery>
 
+<fullquery name="sp_change_matching_display.matching_static_page">
+      <querytext>
 
+	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}%'
+
+      </querytext>
+</fullquery>
+
 </queryset>