Re: I have sub-categories but want to display full category path

From: "Phil Latio" <phil.latio@xxxxxxxxxxxxxxxxx>
Date: Fri, 02 Feb 2007 20:39:28 GMT

Unfortunately you can't do that with a single SQL statement (unless you
use a nested set structure, but that would be real overkill). You have
to walk up the tree in a loop and fetch every parent node until you
reach the root node.

Thanks for your answer.

Cheers

Phil

.

References:
- I have sub-categories but want to display full category path
  - From: Phil Latio
- Re: I have sub-categories but want to display full category path
  - From: Michael Fesser

Prev by Date: Re: PHP 4.4.4 vs Perl 5.8.7 for Object Oriented server code
Next by Date: Re: I have sub-categories but want to display full category path
Previous by thread: Re: I have sub-categories but want to display full category path
Next by thread: Re: I have sub-categories but want to display full category path
Index(es):
- Date
- Thread

Relevant Pages

Re: Bizzare Select single node problem
... command in a loop that scanned attributes.. ... the shame. ... If you think you have a problem with the parent node of some node then ...
(microsoft.public.dotnet.xml)
Re: Is there a way to delete a subset (continous) of child nodes?
... Daniel Rucareanu wrote on 22 sep 2006 in ... loop, a subset of the child nodes of a given DOM parent node? ... var d = document.getElementById ...
(microsoft.public.scripting.jscript)
Is there a way to delete a subset (continous) of child nodes?
... loop, a subset of the child nodes of a given DOM parent node? ...
(comp.lang.javascript)
Is there a way to delete a subset (continous) of child nodes?
... loop, a subset of the child nodes of a given DOM parent node? ...
(microsoft.public.scripting.jscript)
Re: Row of parent of Node in JTree
... > Jim Sculley wrote: ... > saves information about the structure of the tree in an XML file for later ... > parent node of said node so that when I reconstruct the tree I have the ... An XML document already ...
(comp.lang.java.help)