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.1 -r1.2 --- openacs-4/packages/acs-templating/tcl/widget-procs-oracle.xql 22 Sep 2003 21:45:31 -0000 1.1 +++ openacs-4/packages/acs-templating/tcl/widget-procs-oracle.xql 10 Oct 2003 08:23:22 -0000 1.2 @@ -5,8 +5,8 @@ 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 '%' || :search_string || '%' - or lower(pa.email) like '%' || :search_string || '%' + 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) @@ -15,14 +15,14 @@ ( 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, groups g2 where s2.group_id=g2.group_id and - lower(g2.group_name || ' : ' || s2.segment_name) like '%' || :search_string || '%' + lower(g2.group_name || ' : ' || s2.segment_name) like '%' || lower(:search_string) || '%' ) order by party_name 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 @@ 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) @@ -15,14 +15,14 @@ ( 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