Index: openacs-4/packages/dotlrn/www/admin/users-chunk-medium-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/users-chunk-medium-oracle.xql,v
diff -u -r1.16 -r1.16.2.1
--- openacs-4/packages/dotlrn/www/admin/users-chunk-medium-oracle.xql	20 Apr 2004 21:13:22 -0000	1.16
+++ openacs-4/packages/dotlrn/www/admin/users-chunk-medium-oracle.xql	2 Oct 2005 19:02:08 -0000	1.16.2.1
@@ -86,7 +86,7 @@
                                  dotlrn_user_types
                             where a.object_id_one = dotlrn_user_types.group_id
                             and a.object_id_two = acs_rels.object_id_two)
-            and upper(substr(person.last_name, 1, 1)) not in ('[join $dimension_list "\', \'"]')
+            and upper(substr(persons.last_name, 1, 1)) not in ('[join $dimension_list "\', \'"]')
             order by persons.last_name
         </querytext>
     </fullquery>
@@ -134,7 +134,7 @@
             and acs_rels.object_id_one = acs.magic_object_id('registered_users')
             and acs_rels.rel_id = membership_rels.rel_id
             and membership_rels.member_state = 'banned'
-            and upper(substr(person.last_name, 1, 1)) not in ('[join $dimension_list "\', \'"]')
+            and upper(substr(persons.last_name, 1, 1)) not in ('[join $dimension_list "\', \'"]')
             order by persons.last_name
         </querytext>
     </fullquery>
Index: openacs-4/packages/dotlrn/www/admin/users-chunk-medium-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/users-chunk-medium-postgresql.xql,v
diff -u -r1.4 -r1.4.2.1
--- openacs-4/packages/dotlrn/www/admin/users-chunk-medium-postgresql.xql	20 Apr 2004 21:13:22 -0000	1.4
+++ openacs-4/packages/dotlrn/www/admin/users-chunk-medium-postgresql.xql	2 Oct 2005 19:02:08 -0000	1.4.2.1
@@ -86,7 +86,7 @@
                                  dotlrn_user_types
                             where a.object_id_one = dotlrn_user_types.group_id
                             and a.object_id_two = acs_rels.object_id_two)
-            and upper(substr(person.last_name, 1, 1)) not in ('[join $dimension_list "\', \'"]')
+            and upper(substr(persons.last_name, 1, 1)) not in ('[join $dimension_list "\', \'"]')
             order by persons.last_name
         </querytext>
     </fullquery>
@@ -134,7 +134,7 @@
             and acs_rels.object_id_one = acs__magic_object_id('registered_users')
             and acs_rels.rel_id = membership_rels.rel_id
             and membership_rels.member_state = 'banned'
-            and upper(substr(person.last_name, 1, 1)) not in ('[join $dimension_list "\', \'"]')
+            and upper(substr(persons.last_name, 1, 1)) not in ('[join $dimension_list "\', \'"]')
             order by persons.last_name
         </querytext>
     </fullquery>