Index: openacs-4/packages/bug-tracker/www/admin/project-edit-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/admin/Attic/project-edit-oracle.xql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/bug-tracker/www/admin/project-edit-oracle.xql 5 Mar 2003 18:14:15 -0000 1.1.2.1 +++ openacs-4/packages/bug-tracker/www/admin/project-edit-oracle.xql 20 Mar 2003 16:28:27 -0000 1.1.2.2 @@ -3,16 +3,16 @@ oracle8.1.6 - + - select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id - from cc_users u - where upper(nvl(u.first_names || ' ', '') - || nvl(u.last_name || ' ', '') - || u.email || ' ' || - nvl(u.screen_name, '')) like upper('%'||:value||'%') - order by name + select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id + from cc_users u + where upper(nvl(u.first_names || ' ', '') || + nvl(u.last_name || ' ', '') || + u.email || ' ' || + nvl(u.screen_name, '')) like upper('%'||:value||'%') + order by name - - + +