Index: openacs-4/packages/dotlrn-homework/www/folder-chunk-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-homework/www/folder-chunk-oracle.xql,v
diff -u -r1.2.2.1 -r1.2.2.2
--- openacs-4/packages/dotlrn-homework/www/folder-chunk-oracle.xql	3 Apr 2004 00:22:06 -0000	1.2.2.1
+++ openacs-4/packages/dotlrn-homework/www/folder-chunk-oracle.xql	2 Jun 2004 08:48:57 -0000	1.2.2.2
@@ -15,16 +15,16 @@
               content_item.get_path(o.object_id) as item_path,
               lpad(' ',(the_level - 1), ' ') as spaces,
               rels.related_object_id as homework_file_id,
-              c.first_names || ' ' || c.last_name as file_owner_name,
+              p.first_names || ' ' || p.last_name as file_owner_name,
               o.creation_user
-            from cr_item_rels rels, acs_objects o, cr_revisions r, cr_folders f, cc_users c,
+            from cr_item_rels rels, acs_objects o, cr_revisions r, cr_folders f, persons p,
               (select cr_items.*, level as the_level
                from cr_items
                where level >= :min_level and level <= :max_level
                start with item_id in ([join $list_of_folder_ids ", "])
                connect by parent_id = prior item_id) fs_tree
             where o.object_id = fs_tree.item_id
-              and c.user_id(+) = o.creation_user
+              and p.person_id(+) = o.creation_user
               and f.folder_id(+) = fs_tree.item_id
               $qualify_by_owner
               and r.item_id(+) = fs_tree.item_id