Index: openacs-4/packages/forums/www/search-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/search-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/forums/www/search-oracle.xql	2 Jul 2002 02:00:01 -0000	1.1
+++ openacs-4/packages/forums/www/search-oracle.xql	2 Jul 2002 06:11:59 -0000	1.2
@@ -14,7 +14,7 @@
             where forums_messages.forum_id = forums_forums.forum_id
             and forums_forums.package_id = :package_id
             and forums_messages.state = 'approved'
-            and contains(forums_messages.content, :search_text, 1) > 0
+            and contains(forums_messages.content, '%' || :search_text || '%', 1) > 0
             order by the_score desc,
                      forums_messages.posting_date desc
         </querytext>
@@ -32,7 +32,7 @@
             and forums_forums.package_id = :package_id
             and forums_messages.forum_id = forums_forums.forum_id
             and forums_messages.state = 'approved'
-            and contains(forums_messages.content, :search_text, 1) > 0
+            and contains(forums_messages.content, '%' || :search_text || '%', 1) > 0
             order by the_score desc,
                      forums_messages.posting_date desc
         </querytext>