Reading Hierarchical XML in ASP
Posted on 2005-04-05
This is my first XML project, and I am looking into using XML to recieve orders from external clients using ASP(VBScript). I have created some sample data which is Hierarchical, where each XML file can contain 1 or more Orders, each of which can have one or many Order Items. The test data I have created may not be in the best format, so that is my first question, "Is the format OK?"
What I need to do is read through the data and write it away to a backend system through some middleware, so there is no ADO involved. Writing the data is easy, but what i am struggling with is reading the XML data in order to extract the individual attributes. I have read through a few solutions on the site but none of them seem to give me what I need.
I have tried various methods shown in solutions on the site but I always seem to end up with the following:
PS1556513TSP10155 65 TR 13 DUNLOP SP10 TL40188514.87
PS1656513TP3000165 65 TR 13 PIRELLI P3000 TL2018478.22
Any help would be greatly appreciated.
<TDIN_STDESC>155 65 TR 13 DUNLOP SP10 TL</TDIN_STDESC>
<TDIN_STDESC>165 65 TR 13 PIRELLI P3000 TL</TDIN_STDESC>