Hello I have a chain of related names. Parent name Chlidren name AD
AS AD CD AS
BR BR CN AS CS
CP DS I would like to output the relationship in
XML format given the parent name. for AD , output should look like this: <
node label=AD> < node label=CD/> <node label=AS> <node label=BR>
<nodel label=CN/> </node> <nodel label=CS/> </node>
</node> I donot know the length of the relationship. How do I dynamically and
recursively query the database to generate output shown above. This application
is relevant in several areas such as documenting relationship, networking,
relationship between various courses. Thanks for your help