IF ChildNode EXIST?
- Thread starter irade92
- Start date
I am parsing an XML file..and this XML file sometimes has ChildNodes (fund_code)..and sometimes hasn't..I want to check when has and when has not..because if there is not ChiledNodes (fund_code) I have message End..Debug..and so
Minty
AWF VIP
- Local time
- Today, 16:40
- Joined
- Jul 26, 2013
- Messages
- 10,648
I'm glad you have told us about the XML - I suggest you post up your code.
At the moment my crystal ball is low on batteries.
This thread https://www.access-programmers.co.uk/forums/showthread.php?p=1650586#post1650586 however may well provide all the answers you need.
At the moment my crystal ball is low on batteries.
This thread https://www.access-programmers.co.uk/forums/showthread.php?p=1650586#post1650586 however may well provide all the answers you need.
As soon as you get a battery recharger you will see that I have posted my code.. but in case you are shortsighted please take a close look at this..
..prescription.SelectSingleNode("./issued_drug/fund_code") and check does "fund_code" exits as a childnodes or not..if not do something else..
that is..
..prescription.SelectSingleNode("./issued_drug/fund_code") and check does "fund_code" exits as a childnodes or not..if not do something else..
that is..
- Local time
- Today, 16:40
- Joined
- Sep 12, 2006
- Messages
- 15,988
I am not checking the MSXML library but isn't there a .hasChildNodes property for a node. There must be something of that nature.
Without being critical I don't think a half line of code is what was meant by the request "can you post some code please?"
It's not clear whether your code fragment is correct syntactically or not. Does it work? What does it return? Does it return a single node or does it return a set of all of the nodes in the XML file with that prefix? Are you walking a tree, or trying to extract data? It's all germane. Hence it would be useful to see the context of the code fragment.
Without being critical I don't think a half line of code is what was meant by the request "can you post some code please?"
It's not clear whether your code fragment is correct syntactically or not. Does it work? What does it return? Does it return a single node or does it return a set of all of the nodes in the XML file with that prefix? Are you walking a tree, or trying to extract data? It's all germane. Hence it would be useful to see the context of the code fragment.
Minty
AWF VIP
- Local time
- Today, 16:40
- Joined
- Jul 26, 2013
- Messages
- 10,648
Well I've cleaned my glasses and I can't see any more than I saw before.
I can't see any attempt on how you are checking for a node and do something based on it being there or not.
Luckily, now that we have determined that you are attempting to parse an XML file and I can see more clearly, I found a thing called google, and it found this;
stackoverflow.com
Which recursively will list child nodes until you are bored.
I can't see any attempt on how you are checking for a node and do something based on it being there or not.
Luckily, now that we have determined that you are attempting to parse an XML file and I can see more clearly, I found a thing called google, and it found this;
Loop through a full XML document
I'm looking for a way to loop through all the nodes of my XML document. XML file sample <root> <llnode created="2005-05-24T15:26:24" createdby="42912153" createdbyname="" descriptio...
stackoverflow.com
Which recursively will list child nodes until you are bored.
Maybe you need more than a cleared glasses...hm..
Maybe this can help you...this is just a line of a code that works perfectly...for example in an XML file with 5 nodes of "prescription" and 5 childnodes of "issued_drug" and 4 childnodes of "fund_code"...so ..one childnode "fund_code" is missing. Doing parsing with for..next..there is no value of one childnodes ie "fund_code" ..There is .hasChildNodes yes...but i need to specify the name of child node..
Maybe this can help you...this is just a line of a code that works perfectly...for example in an XML file with 5 nodes of "prescription" and 5 childnodes of "issued_drug" and 4 childnodes of "fund_code"...so ..one childnode "fund_code" is missing. Doing parsing with for..next..there is no value of one childnodes ie "fund_code" ..There is .hasChildNodes yes...but i need to specify the name of child node..
in the meantime i solved this with a little trick...since I store value od each childnodes("fund_code") in a variable and then in a table, after storing in a table I initialize variabile to null...so if there is no value of "fund_code" I did Resume Next and go on for next loop..That is
...and maybe get the ball bearings sharpened, yes?
