Index: openacs-4/packages/acs-content-repository/tcl/filter-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/filter-procs-oracle.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-content-repository/tcl/filter-procs-oracle.xql	21 Sep 2001 05:01:38 -0000	1.4
+++ openacs-4/packages/acs-content-repository/tcl/filter-procs-oracle.xql	11 Jul 2002 12:56:28 -0000	1.5
@@ -2,6 +2,15 @@
 <queryset>
    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
+
+<partialquery name="item::get_content.content_as_text">
+	<querytext>
+
+	, content.blob_to_string(content) as text
+
+	</querytext>
+</partialquery>
+
 <fullquery name="content::get_folder_labels.get_url">      
       <querytext>
 
Index: openacs-4/packages/acs-content-repository/tcl/filter-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/filter-procs-postgresql.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/acs-content-repository/tcl/filter-procs-postgresql.xql	8 Dec 2001 01:17:59 -0000	1.6
+++ openacs-4/packages/acs-content-repository/tcl/filter-procs-postgresql.xql	11 Jul 2002 12:56:28 -0000	1.7
@@ -2,6 +2,14 @@
 <queryset>
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
+<partialquery name="item::get_content.content_as_text">
+	<querytext>
+
+	, content as text
+
+	</querytext>
+</partialquery>
+
 <fullquery name="content::get_folder_labels.get_url">      
       <querytext>
 
Index: openacs-4/packages/acs-content-repository/tcl/filter-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/filter-procs.tcl,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/acs-content-repository/tcl/filter-procs.tcl	21 Sep 2001 05:01:38 -0000	1.7
+++ openacs-4/packages/acs-content-repository/tcl/filter-procs.tcl	11 Jul 2002 12:56:28 -0000	1.8
@@ -95,7 +95,7 @@
   }  
 
   if { [string equal [lindex [split $mime_type "/"] 0] "text"] } {
-    set text_sql ",\n    content.blob_to_string(content) as text"
+    set text_sql [db_map content_as_text]
   } else {
     set text_sql ""
   }