Index: openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql,v diff -u -r1.32.2.1 -r1.32.2.2 --- openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql 10 Dec 2005 11:55:49 -0000 1.32.2.1 +++ openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql 19 Mar 2006 21:51:06 -0000 1.32.2.2 @@ -128,15 +128,15 @@ select case when file_storage.get_content_type(i.item_id) = 'content_folder' - then :folder_url || '?' || :extra_vars || '&folder_id=' - else :file_url || '?' || :extra_vars || '&file_id=' + then :folder_url || '?folder_id=' + else :file_url || '?file_id=' end || i.item_id, file_storage.get_title(i.item_id) from cr_items i where item_id not in (select i2.item_id from cr_items i2 connect by prior i2.parent_id = i2.item_id - start with i2.item_id = file_storage.get_parent_id(:root_folder_id)) + start with i2.item_id = :root_folder_id) connect by prior i.parent_id = i.item_id start with item_id = :start_id order by level desc