We have the following XML sturcture:<br><br><TCAResult><br> <TCACall><br> <CallID>1</CallID><br> <ConsumerID>1111</ConsumerID><br> <DateAndTime>01/01/2000 11:52 AM</DateAndTime><br> <OperatorCode>AB1</OperatorCode><br> </TCACall><br> <TCACall><br> <CallID>2</CallID><br> <CallerComment>BBB</CallerComment><br> <ConsumerID>2222</ConsumerID><br> <DateAndTime>02/01/2000 11:52 AM</DateAndTime><br> <OperatorCode>AB2</OperatorCode><br> </TCACall><br> <TCACall><br> <CallID>3</CallID><br> <CallerComment>CCC</CallerComment><br> <ConsumerID>3333</ConsumerID><br> <DateAndTime>03/01/2000 11:52 AM</DateAndTime><br> <OperatorCode>AB3</OperatorCode><br> </TCACall><br> <ResultCode>0</ResultCode><br></TCAResult><br><br>If you notice, the first Node is missing the <CallerComment> tag. My question is this:<br><br>If you're iterating through the list of Nodes in the xml structure, do all nodes have to have the same tags. The reason I ask is that with the tag missing in the first Node, the MSXML parser jumps down to the second node and grabs its <CallerComment> and uses it for the first Node's caller comment. Then the last caller comment is blank. I don't think it should work this way, but then maybe I don't know all the rules dealing with XML. If I put an empty tag in for <CallerComment/> (<--Like that) for the first record then the document parses correctly. If anyone has any information on this topic I'd like it if you would post a reply.<br><br>Sample output for the first node:<br><br>CallID=1<br>CallerComment=BBB <-- This should be blank, not BBB.<br>ConsumerID=1111<br>DateAndTime=01/01/2000 11:52 AM<br>OperatorCode=AB1<br><br>Thanks, <p>Steve<br><a href=mailto:tribesaddict@swbell.net>tribesaddict@swbell.net</a><br><a href= > </a><br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
XML Structural question...
- Thread starter Snaggs
- Start date
Dear Steve,<br><br>I can't state this with any certainty, nor can I provide an example. But I believe you can write a DTD for your document that defines the <CallerComment> entity as 'optional'. That might be the technique you are looking for.<br><br>Good luck<br>-pete
- Thread starter
- #3
Pete,<br><br>Thanks for the response, but I figured out what was wrong with the approach. I figured I'd share it with others before they make the same mistake.<br><br>We were using GetElementByName off the DOM. However, when you use this, it references the elements from the document level and not the node level. This make perfect sense when you stop and think about it. When you tell it to get the Element by name, it get's the first one, regardless of the node it resides under. What we had to do was get the node and then look at the child nodes. Then the CallerComment tag would not show up in the ChildNodes where they didn't exist.<br><br>Now it works great and gives us the expected results.<br> <p>Steve<br><a href=mailto:tribesaddict@swbell.net>tribesaddict@swbell.net</a><br><a href= > </a><br>
- Status
