Index: openacs-4/packages/acs-templating/tcl/widget-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/tcl/Attic/widget-procs-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-templating/tcl/widget-procs-oracle.xql	10 Oct 2003 08:23:22 -0000	1.2
+++ openacs-4/packages/acs-templating/tcl/widget-procs-oracle.xql	12 Oct 2003 18:03:22 -0000	1.3
@@ -4,9 +4,10 @@
 <fullquery name="template::data::transform::party_search.search_persons">      
       <querytext>
         select (first_names || ' ' || last_name) as name, pe.person_id from persons pe, parties pa 
-        where pe.person_id=pa.party_id and
-        lower(pe.first_names || ' ' || pe.last_name) like '%' || lower(:search_string) || '%'
-        or lower(pa.email) like '%' || lower(:search_string) || '%'
+        where pe.person_id=pa.party_id and (
+          lower(pe.first_names || ' ' || pe.last_name) like '%' || lower(:search_string) || '%'
+          or lower(pa.email) like '%' || lower(:search_string) || '%'
+	)
         order by lower(first_names || ' ' || last_name)
       </querytext>
 </fullquery>