Webmaster Forum / ColdFusion / Advanced Techniques / May 2006

What's the best way to output the entries of an XML file with the following
structure as a nested list  (actually it needs to become a form where all
entries can be checked).

I can output each level (see code) but it seems not to be possible to nest the
for-loops.

Any hints if it's possible with XPath directly or do I need to save the result
of one loop to output within the other or would it even be better to make a
query out of the XML result?

<menues>
    <menu name="Essen">
        <eintrag name="Fisch" aktion="message" variables="Fisch" nr="1001"/>
        <eintrag name="Fleisch" aktion="message" variables="Fleisch" nr="1002"/>
        <eintrag name="Fr?hst?ck" aktion="message" variables="Fr?hst?ck" nr="1010"/>
        <eintrag name="Babynahrung" aktion="message" variables="Babynahrung"
nr="1012"/>
        <eintrag name="Anderes" aktion="message" variables="Essen, anderes"
nr="1013"/>
    </menu>
    <menu name="Trinken">
        <eintrag name="S?fte" aktion="message" variables="S?fte" nr="2004"/>
        <eintrag name="Sirup" aktion="message" variables="Sirup" nr="2006"/>
        <eintrag name="Aperitif" aktion="message" variables="Aperitif" nr="2008"/>
    </menu>
    <menu name="Haushalt">
        <eintrag name="Putzen" aktion="message" variables="Putzen" nr="3001"/>
        <eintrag name="Garten" aktion="message" variables="Garten" nr="3003"/>
        <eintrag name="Blumen" aktion="message" variables="Blumen" nr="3004"/>
    </menu>

<cfscript>
    myxmldoc = XmlParse(myxml);

   
    selectedElements = XmlSearch(myxmldoc, "/menues/menu");
    for (i = 1; i LTE ArrayLen(selectedElements); i = i + 1)
        writeoutput("<b>" & selectedElements[i].XmlAttributes.name & "</b><br>" );
       
        selectedSubElements = XmlSearch(myxmldoc, "/menues/menu/eintrag");
        for (i = 1; i LTE ArrayLen(selectedSubElements); i = i + 1)
            writeoutput(selectedSubElements[i].XmlAttributes.name & "<br>");
</cfscript>