Index: openacs-4/packages/fs-portlet/www/fs-portlet-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/fs-portlet/www/fs-portlet-oracle.xql,v diff -u -r1.8 -r1.9 --- openacs-4/packages/fs-portlet/www/fs-portlet-oracle.xql 25 Apr 2002 20:34:38 -0000 1.8 +++ openacs-4/packages/fs-portlet/www/fs-portlet-oracle.xql 22 May 2002 08:50:54 -0000 1.9 @@ -6,7 +6,7 @@ select file_storage.get_package_id(fs_objects.object_id) as package_id, - decode(fs_objects.type, 'URL', (select site_node.url(site_nodes.node_id) + decode(fs_objects.type, 'url', (select site_node.url(site_nodes.node_id) from site_nodes where site_nodes.object_id = file_storage.get_package_id(fs_objects.parent_id)), (select site_node.url(site_nodes.node_id) @@ -28,7 +28,7 @@ select file_storage.get_package_id(fs_objects.object_id) as package_id, - decode(fs_objects.type, 'URL', (select site_node.url(site_nodes.node_id) + decode(fs_objects.type, 'url', (select site_node.url(site_nodes.node_id) from site_nodes where site_nodes.object_id = file_storage.get_package_id(fs_objects.parent_id)), (select site_node.url(site_nodes.node_id)