Forum OpenACS Development: Re: content_item__new broken for items with non-cr parents

Collapse
5: Re: content_item__new broken for items with non-cr parents (response to 1)
Posted by Dave Bauer on 01/09/06 05:26 PM
Perhaps something like this on oracle?

 select
      item_id into v_folder_id
    from
	(select item_id, level from
      cr_items
    connect by
      prior parent_id = item_id
    start with
      item_id = get_root_folder.item_id)
	where level = 2;