thank you. it helped ! first i was surprised, that i dind't try this
way before, and maybe i did. but with your answer i knew that the
problem was somewhere else. and it was in the recursive setting. i
need recursive set to 2 and it was set somewhere to 1. that was the
problem. quite obvious, when
> i would like to do the following. i have a table, lets call it
> "softwaretype". in this table i want to store main classes (e.g.
> Internet software), but also subclasses (e.g. Internet Browsers, Mail,
> FTP...). i add an "parent_id" field which stores the id of the
> "parent". if the type is a
i would like to do the following. i have a table, lets call it
"softwaretype". in this table i want to store main classes (e.g.
Internet software), but also subclasses (e.g. Internet Browsers, Mail,
FTP...). i add an "parent_id" field which stores the id of the
"parent". if the type is a main clas