Thanks everyone for responding to my question.
Also, Kees thanks for looking for the lost code.
Curtney
On Thursday 07 October 2004 12:57 am, Kees Jongenburger wrote:
> Hi , I don't understand how you can combine both.
> Here is a bit more information about my aproach
> my builder contains the following fields
>
> |number|parent|pos|
>
> my tree will look like this
>
> {1,0,0}
> {2,1,0}
> {4,2,0}
> {5,2,1}
> {3,1,1}
>
> you can make on asumtion
> 1-a subcategory is created after it's parent
>
> all you have to do now is get a list of the builder sorted by parentid
> and posrel the list will look like this
>
> {1,0,0}
> {2,1,0}
> {3,1,1}
> {4,2,0}
> {5,2,1}
>
> then you can create the three *usualy with java code*
> if if parent id is the same as the previous parent id , search
> downwards for nodes that have the parent id of the current node. The
> real advanage is that you only have to query the database once and you
> can to most of the sorting in the database
>
> I will try to find back the "lost" code
