Index: openacs-4/packages/acs-templating/tcl/widget-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-templating/tcl/Attic/widget-procs-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-templating/tcl/widget-procs-postgresql.xql	22 Sep 2003 21:45:31 -0000	1.1
+++ openacs-4/packages/acs-templating/tcl/widget-procs-postgresql.xql	10 Oct 2003 08:23:23 -0000	1.2
@@ -5,8 +5,8 @@
       <querytext>
         select (first_names || ' ' || last_name) as name, pe.person_id from persons pe 
         join parties pa on pe.person_id=pa.party_id
-        where lower(pe.first_names || ' ' || pe.last_name) like '%' || :search_string || '%'
-        or lower(pa.email) like '%' || :search_string || '%'
+        where 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>
@@ -15,14 +15,14 @@
       <querytext>
         (
         select g1.group_name as party_name, g1.group_id as party_id from groups g1
-        where lower(g1.group_name) like '%' || :search_string || '%'
+        where lower(g1.group_name) like '%' || lower(:search_string) || '%'
         )
         union
         (
         select g2.group_name || ' : ' || s2.segment_name as party_name, s2.segment_id as party_id
         from rel_segments s2
         join groups g2 on s2.group_id=g2.group_id
-        where lower(g2.group_name || ' : ' || s2.segment_name) like '%' || :search_string || '%'
+        where lower(g2.group_name || ' : ' || s2.segment_name) like '%' || lower(:search_string) || '%'
         )
         order by party_name
       </querytext>