Index: openacs-4/packages/dotlrn/www/admin/users-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/admin/Attic/users-oracle.xql,v
diff -u -r1.11 -r1.12
--- openacs-4/packages/dotlrn/www/admin/users-oracle.xql	7 Jun 2002 03:19:55 -0000	1.11
+++ openacs-4/packages/dotlrn/www/admin/users-oracle.xql	7 Jun 2002 04:47:38 -0000	1.12
@@ -14,7 +14,7 @@
       select count(*) from (
         select acs_rels.object_id_two
         from acs_rels
-        where acs_rels.object_id_one = acs.magic_object_id('registered_users')
+        where acs_rels.object_id_one = (select acs.magic_object_id('registered_users') from dual)
         MINUS
         select acs_rels.object_id_two
         from acs_rels, dotlrn_user_types
@@ -29,7 +29,7 @@
       from persons,
            acs_rels,
            membership_rels
-      where acs_rels.object_id_one = acs.magic_object_id('registered_users')
+      where acs_rels.object_id_one = (select acs.magic_object_id('registered_users') from dual)
       and acs_rels.object_id_two = persons.person_id
       and acs_rels.rel_id = membership_rels.rel_id
       and membership_rels.member_state = 'banned'