Index: openacs-4/packages/acs-content-repository/tcl/content-item-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/content-item-procs.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/acs-content-repository/tcl/content-item-procs.xql 21 Jun 2005 13:41:01 -0000 1.3 +++ openacs-4/packages/acs-content-repository/tcl/content-item-procs.xql 4 Jun 2006 00:45:23 -0000 1.4 @@ -32,4 +32,39 @@ - \ No newline at end of file + + + select cf.*, + ci.name, + ci.item_id, + ci.live_revision, + ci.latest_revision, + ci.locale, + ci.publish_status, + ci.content_type, + ci.storage_type + from cr_folders cf, + cr_items ci + where ci.item_id = cf.folder_id + and ci.item_id = :item_id + + + + + + select name + from cr_items + where parent_id = :parent_id + + + + + + select item_id + from cr_items + where name = :name + and parent_id = :parent_id + + + +