postgresql7.1
select content_item__move(
:mv_item_id,
:folder_id
);
select
content_item__get_path( :folder_id, null )
from
dual
select
content_item__get_title(item_id, 'f') as title,
content_item__get_path(item_id,:root_id) as name,
item_id, parent_id
from
cr_items
where
item_id in ([join $clip_items ","])
and
-- only for those items which user has cm_write
cms_permission__permission_p(item_id, :user_id, 'cm_write') = 't'