Index: openacs-4/packages/file-storage/www/file-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/www/Attic/file-oracle.xql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/file-storage/www/file-oracle.xql	25 Sep 2003 13:55:04 -0000	1.9
+++ openacs-4/packages/file-storage/www/file-oracle.xql	11 Dec 2003 21:40:04 -0000	1.10
@@ -18,7 +18,8 @@
        		r.title as name,
        		acs_permission.permission_p(:file_id,:user_id,'write') as write_p,
        		acs_permission.permission_p(:file_id,:user_id,'delete') as delete_p,
-       		acs_permission.permission_p(:file_id,:user_id,'admin') as admin_p
+       		acs_permission.permission_p(:file_id,:user_id,'admin') as admin_p,
+                content_item.get_path(o.object_id, :root_folder_id) as file_url
 	from   acs_objects o, cr_revisions r, cr_items i
 	where  o.object_id = :file_id
 	and    i.item_id   = o.object_id