Index: openacs-4/packages/file-storage/tcl/file-storage-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/tcl/file-storage-procs.xql,v diff -u -r1.6 -r1.7 --- openacs-4/packages/file-storage/tcl/file-storage-procs.xql 2 May 2002 20:38:10 -0000 1.6 +++ openacs-4/packages/file-storage/tcl/file-storage-procs.xql 22 May 2002 08:50:52 -0000 1.7 @@ -69,4 +69,43 @@ + + + select fs_objects.* + from fs_objects + where fs_objects.object_id = :object_id + + + + + + select fs_objects.*, + cr_items.storage_type, + cr_items.storage_area_key, + cr_revisions.title + from fs_objects, + cr_items, + cr_revisions + where fs_objects.object_id = :object_id + and fs_objects.object_id = cr_items.item_id + and fs_objects.live_revision = cr_revisions.revision_id + + + + + + select content + from cr_revisions + where revision_id = $live_revision + + + + + + select filename + from cr_revisions + where revision_id = :live_revision + + +