Forum OpenACS Development: Re: To display tree Hierarichy with the following condition

Collapse
3: Re: To display tree Hierarichy with the following condition (response to 1)
Posted by Tom Jackson on 04/21/07 03:02 AM 
select
 id,
 parent_id
from
 my_hierarchy_table
where
 id = :myid
or
 parent_id = :myid
order by
 id,
 parent_id;

But this assumes that id is always less than parent_id, and that the ordering should follow the order of input of the rows. Overall, not a great strategy for creating a hierarchy.

Collapse
4: Re: To display tree Hierarichy with the following condition (response to 3)
Posted by roohie natt on 04/21/07 07:39 AM
but i want something like this

GRP1
GRP2
GRP4
GRP5

using recursion

Collapse
5: Re: To display tree Hierarichy with the following condition (response to 4)
Posted by Tom Jackson on 04/23/07 07:24 PM
Recursion is a procedural language concept. This is the wrong forum for this type of question. You have also not stated a question which requires recursion.

proc group_recurse { list } {
  if {[llength $list] > 1} {
    return "GRP[lindex $list 0]\n[group_recurse [lrange $list 1 end]]"
  } else {
    return "GRP[lindex $list 0]\n"
  }
}
puts [group_recurse {1 2 4 5}]