XML - nested nodes issue - ASP Classic

[imaginemn]

One of my clients has an issue with an ASP Classic script that I need help with.

The script works fine with the exception of the nested day-plan nodes. I need some sort of logic to loop through the nested records. The script only brings back the first record and not any of the nested one's in the day-plans array node.

Any help will be appreciated! If you know how to do it in PHP, ColdFusion or even .NET....that may point me in the right direction to fixing this. It's been a while for me so looking for help!

Thanks in advance!

XML FILE

<?xml version="1.0" encoding="UTF-8"?>
<lessons type="array">
  <lesson>
    <club type="integer">174</club>
    <resource>STUDIO 2</resource>
    <day-plans type="array">
      <day-plan>
        <day-plan type="integer">4</day-plan>
        <res-units type="integer">75</res-units>
        <reservation type="integer">35342</reservation>
        <start-time type="datetime">2008-11-14T05:45:00-06:00</start-time>
      </day-plan>
      <day-plan>
        <day-plan type="integer">6</day-plan>
        <res-units type="integer">75</res-units>
        <reservation type="integer">35342</reservation>
        <start-time type="datetime">2008-11-14T05:45:00-06:00</start-time>
      </day-plan>
    </day-plans>
  </lesson>
  <lesson>
    <club type="integer">177</club>
    <resource>STUDIO 1</resource>
    <day-plans type="array">
      <day-plan>
        <day-plan type="integer">6</day-plan>
        <res-units type="integer">75</res-units>
        <reservation type="integer">35342</reservation>
        <start-time type="datetime">2008-11-14T05:45:00-06:00</start-time>
      </day-plan>
    </day-plans>
  </lesson>
</lessons>

ASP Parser Script

<%
Set objXML = Server.CreateObject("Microsoft.XMLDOM")
objXML.async = False
objXML.Load (Server.MapPath("myfile.xml"))

i=0
For Each route in objXML.documentElement.SelectNodes("/lessons/lesson")
	response.write TRIM(objXML.getElementsByTagName("club").item(i).childNodes(0).text) & "<BR>"
	response.write TRIM(objXML.getElementsByTagName("resource").item(i).childNodes(0).text) & "<BR>"
	response.write TRIM(objXML.getElementsByTagName("day-plan").item(i).childNodes(0).text) & "<BR>"
i=i+1
next
%>

[Costin Trifan]

you need to do another foreach for <day-plan>