Jump to content

XML data to HTML using classic ASP - seems easy, but I'm struggling


alangford
 Share

Recommended Posts

Using classic ASP and MSXML2.DOMDocument, I'm trying to convert this XML into a HTML table using classic ASP. Can anyone point me in the right direction? This is the result I want:tableex.gif This is the XML:

<?xml version="1.0"?><inv-balance><item color-code="50" description="G200 ASH.GREY S" item-number="0620404A3" price="$2.60" size-code="3" special-expiry="06/30/12" specialPrice="$1.92" style-code="G200">  <transit-time days="0">386</transit-time>  <transit-time days="1">6602</transit-time>  <transit-time days="2">9090</transit-time>  <transit-time days="3">88755</transit-time>  <transit-time days="5">2394</transit-time>  <transit-time days="All">107227</transit-time>  </item>  <item color-code="50" description="G200 ASH.GREY M" item-number="0620404A4" price="$2.60" size-code="4" special-expiry="06/30/12" specialPrice="$1.92" style-code="G200">  <transit-time days="0">422</transit-time>  <transit-time days="1">9428</transit-time>  <transit-time days="2">12162</transit-time>  <transit-time days="3">86798</transit-time>  <transit-time days="5">3523</transit-time>  <transit-time days="All">112333</transit-time>  </item>  <item color-code="50" description="G200 ASH.GREY L" item-number="0620404A5" price="$2.60" size-code="5" special-expiry="06/30/12" specialPrice="$1.92" style-code="G200">  <transit-time days="0">548</transit-time>  <transit-time days="1">14810</transit-time>  <transit-time days="2">17335</transit-time>  <transit-time days="3">84832</transit-time>  <transit-time days="5">5611</transit-time>  <transit-time days="All">123136</transit-time>  </item>  <item color-code="50" description="G200 ASH.GREY XL" item-number="0620404A6" price="$2.60" size-code="6" special-expiry="06/30/12" specialPrice="$1.92" style-code="G200">  <transit-time days="0">644</transit-time>  <transit-time days="1">15040</transit-time>  <transit-time days="2">16954</transit-time>  <transit-time days="3">50635</transit-time>  <transit-time days="5">5995</transit-time>  <transit-time days="All">89268</transit-time>  </item>  <item color-code="50" description="G200 ASH.GREY 2XL" item-number="0620404A7" price="$4.19" size-code="7" special-expiry="06/30/12" specialPrice="$3.39" style-code="G200">  <transit-time days="0">343</transit-time>  <transit-time days="1">5374</transit-time>  <transit-time days="2">7016</transit-time>  <transit-time days="3">26033</transit-time>  <transit-time days="5">2592</transit-time>  <transit-time days="All">41358</transit-time>  </item>  <item color-code="50" description="G200 ASH.GREY 3XL" item-number="0620404A8" price="$4.33" size-code="8" special-expiry="06/30/12" specialPrice="$3.39" style-code="G200">  <transit-time days="0">153</transit-time>  <transit-time days="1">1242</transit-time>  <transit-time days="2">1896</transit-time>  <transit-time days="3">4699</transit-time>  <transit-time days="5">803</transit-time>  <transit-time days="All">8793</transit-time>  </item>  <item color-code="50" description="G200 ASH.GREY 4XL" item-number="0620404A9" price="$4.49" size-code="9" special-expiry="06/30/12" specialPrice="$3.39" style-code="G200">  <transit-time days="0">18</transit-time>  <transit-time days="1">78</transit-time>  <transit-time days="2">159</transit-time>  <transit-time days="3">237</transit-time>  <transit-time days="5">62</transit-time>  <transit-time days="All">554</transit-time>  </item>  <item color-code="50" description="G200 ASH.GREY 5XL" item-number="0620404AA" price="$4.63" size-code="0" special-expiry="06/30/12" specialPrice="$3.39" style-code="G200">  <transit-time days="0">16</transit-time>  <transit-time days="1">295</transit-time>  <transit-time days="2">215</transit-time>  <transit-time days="3">2127</transit-time>  <transit-time days="5">119</transit-time>  <transit-time days="All">2772</transit-time>  </item>  </inv-balance>

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...