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
+
+
+
+