Index: openacs-4/packages/file-storage/tcl/file-storage-rss-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/tcl/file-storage-rss-procs-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/file-storage/tcl/file-storage-rss-procs-oracle.xql 13 Jan 2005 13:58:12 -0000 1.2
+++ openacs-4/packages/file-storage/tcl/file-storage-rss-procs-oracle.xql 3 Sep 2024 15:37:38 -0000 1.3
@@ -10,38 +10,6 @@
connect by prior item_id = parent_id
start with item_id = :folder_id)
-
+
-
-
- select * from (
- select o.object_id as item_id,
- o.title,
- o.name,
- o.file_upload_name,
- o.type,
- o.content_size,
- to_char(o.last_modified,'YYYY-MM-DD HH24:MI:SS') as publish_date_ansi,
- r.description,
- r.revision_id
- from fs_objects o,
- cr_revisions r
- where $parent_clause
- and type != 'folder'
- and $revisions_clause
- order by last_modified desc
- ) where rownum < :max_items + 1
-
-
-
-
-
- select (max(last_modified)-to_date('1970-01-01','YYYY-MM-DD'))*60*60*24 as last_update
- from fs_rss_subscrs s, fs_objects f
- where s.subscr_id = :summary_context_id
- and f.parent_id = s.folder_id
- and f.type != 'folder'
-
-
-