PowerBuilder

Get XML Attribute Value by Path

See more XML Examples

Demonstrates how to get an attribute value by path. PowerBuilder

integer li_rc
integer li_Success
oleobject loo_Xml
string ls_Path
string ls_AttrValue
integer i

li_Success = 0

// The XML used in this example contains the following:
// This example will get the value of the "spay-neuter" attribute for each pig.

// <pig-rescue>
//   <herd name="Cathy">
// 	<species name="pot belly pig">
// 	    <animal>
// 	        <name>Molly II</name>
// 	        <birth>February, 1998</birth>
// 			<in-date>January, 2000</in-date>
// 			<from>Middle Ave.</from>
// 			<gender spay-neuter="yes">F</gender>
// 			<info>Molly came from a place where an old, ill man had too many animals.
// 	              	The animals were seldom fed and rats would eat the newborn piglets.
// 	             	 When Molly was found at one week old, she was the only piglet of 
// 	              	her siblings who did not get stepped on by a cow. She is a sweet, 
// 	              	friendly pig who likes to hang out on Cathy's porch on the lounge 
// 	              	pad.
// 			</info>
// 		</animal>
// 	    <animal>
// 			<name>Nigel</name>
// 			<birth>June, 1991</birth>
// 			<in-date>August, 1991</in-date>
// 			<from>Breeder</from>
// 			<gender spay-neuter="no">M</gender>
// 			<info>
// 			 	Nigel was the first pig and the reason for the rescue in the
// 			 	first place. He is 13 now and doing well, but takes a number 
// 				of medications, as you can see below.
// 			</info>
// 		</animal>		
// 	</species>
//   </herd>
// </pig-rescue>

loo_Xml = create oleobject
li_rc = loo_Xml.ConnectToNewObject("Chilkat.Xml")
if li_rc < 0 then
    destroy loo_Xml
    MessageBox("Error","Connecting to COM object failed")
    return
end if
li_Success = loo_Xml.LoadXmlFile("qa_data/xml/twoPigs.xml")

// Use the ChilkatPath method to return the value of a particular attribute at a given path.
// A path ending with "(attributeName)" will return the value for the given attribute.
ls_Path = "herd|species|animal[0]|gender|(spay-neuter)"
ls_AttrValue = loo_Xml.ChilkatPath(ls_Path)
Write-Debug "1st pig spay-neuter: " + ls_AttrValue

ls_Path = "herd|species|animal[1]|gender|(spay-neuter)"
ls_AttrValue = loo_Xml.ChilkatPath(ls_Path)
Write-Debug "2nd pig spay-neuter: " + ls_AttrValue

// We could also do it like this:
ls_Path = "herd|species|animal[i]|gender|(spay-neuter)"
i = 0
do while i < loo_Xml.NumChildrenAt("herd|species")
    loo_Xml.I = i
    Write-Debug "spay-neuter for pig number " + string(i + 1) + ": " + loo_Xml.ChilkatPath(ls_Path)
    i = i + 1
loop


destroy loo_Xml