Greetings All,

I have an XML string that has an element called <coordinates>.

I want to get the value of <coordinates>, but I can't seem to figure out how 
to reference it directly.

Below is the code for my function and the XML string...

If someone can point me in the right direction, I would appreciate it.

Thanks!!

Paul

Argument is string as 'strXML'
Return value is real as 'latitude'

messagebox("The passed string is",strXML)

real latitude

PBDOM_Builder pbdom_bldr
pbdom_document pbdom_doc
PBDOM_OBJECT pbdom_obj_array[]
PBDOM_Element pbdom_elem_root

pbdom_bldr = Create PBDOM_Builder
pbdom_doc = pbdom_bldr.BuildFromString(strXML)
pbdom_elem_root = pbdom_doc.GetRootElement()
boolean result
result = pbdom_doc.getcontent(pbdom_obj_array)

if result <> true then
 messagebox("Failed to getcontent",string(result))
else
 messagebox("Succeeded in getting getcontent",string(result))
end if


string coordinates_data
//coordinates_data = pbdom_doc.12.gettext()
coordinates_data = pbdom_elem_root.GetTextNormalize()

messagebox("coordinates_data",coordinates_data)

messagebox("LowerBound",string(lowerbound(pbdom_obj_array)))
messagebox("UpperBound",string(upperbound(pbdom_obj_array)))

integer i
for i = 1 to UpperBound(pbdom_obj_array)
 messagebox("Element is",string(pbdom_obj_array[i]))
next

return latitude

XML String is:

<?xml version="1.0" encoding="UTF-8" ?>
<kml xmlns="http://earth.google.com/kml/2.0"><Response>
  <name>2 Stanley Pl., Far Hills, NJ 07931</name>
  <Status>
    <code>200</code>
    <request>geocode</request>
  </Status>
  <Placemark id="p1">
    <address>2 Stanley Pl, Far Hills, NJ 07934, USA</address>
    <AddressDetails Accuracy="8" 
xmlns="urn:oasis:names:tc:ciq:xsdschema:xAL:2.0"><Country><CountryNameCode>US</CountryNameCode><CountryName>USA</CountryName><AdministrativeArea><AdministrativeAreaName>NJ</AdministrativeAreaName><SubAdministrativeArea><SubAdministrativeAreaName>Morris</SubAdministrativeAreaName><Locality><LocalityName>Far 
Hills</LocalityName><Thoroughfare><ThoroughfareName>2 Stanley 
Pl</ThoroughfareName></Thoroughfare><PostalCode><PostalCodeNumber>07934</PostalCodeNumber></PostalCode></Locality></SubAdministrativeArea></AdministrativeArea></Country></AddressDetails>
    <ExtendedData>
      <LatLonBox north="40.7429886" south="40.7366934" east="-74.6749984" 
west="-74.6812936" />
    </ExtendedData>
    <Point><coordinates>-74.6781460,40.7398410,0</coordinates></Point>
  </Placemark>
</Response></kml>

Paul

You could use GetChildElement/GetChildElements to find the coordinates
element. Before this function existed in PB I wrote a recursive
function to find an element. I used GetContent to retrieve the array of
elements of the first level, checked for type element, if found checked
for the name of the element I'm searching. If not found, I pass the
element to the function again.

Regards
Arthur
-- 



Paul Murray wrote:

> Greetings All,
> 
> I have an XML string that has an element called <coordinates>.
> 
> I want to get the value of <coordinates>, but I can't seem to figure
> out how to reference it directly.
> 
> Below is the code for my function and the XML string...
> 
> If someone can point me in the right direction, I would appreciate it.
> 
> Thanks!!
> 
> Paul
> 
> Argument is string as 'strXML'
> Return value is real as 'latitude'
> 
> messagebox("The passed string is",strXML)
> 
> real latitude
> 
> PBDOM_Builder pbdom_bldr
> pbdom_document pbdom_doc
> PBDOM_OBJECT pbdom_obj_array[]
> PBDOM_Element pbdom_elem_root
> 
> pbdom_bldr = Create PBDOM_Builder
> pbdom_doc = pbdom_bldr.BuildFromString(strXML)
> pbdom_elem_root = pbdom_doc.GetRootElement()
> boolean result
> result = pbdom_doc.getcontent(pbdom_obj_array)
> 
> if result <> true then
> messagebox("Failed to getcontent",string(result))
> else
> messagebox("Succeeded in getting getcontent",string(result))
> end if
> 
> 
> string coordinates_data
> //coordinates_data = pbdom_doc.12.gettext()
> coordinates_data = pbdom_elem_root.GetTextNormalize()
> 
> messagebox("coordinates_data",coordinates_data)
> 
> messagebox("LowerBound",string(lowerbound(pbdom_obj_array)))
> messagebox("UpperBound",string(upperbound(pbdom_obj_array)))
> 
> integer i
> for i = 1 to UpperBound(pbdom_obj_array)
> messagebox("Element is",string(pbdom_obj_array[i]))
> next
> 
> return latitude
> 
> XML String is:
> 
> <?xml version="1.0" encoding="UTF-8" ?>
> <kml xmlns="http://earth.google.com/kml/2.0"><Response>
>  <name>2 Stanley Pl., Far Hills, NJ 07931</name>
>  <Status>
>    <code>200</code>
>    <request>geocode</request>
>  </Status>
>  <Placemark id="p1">
>    <address>2 Stanley Pl, Far Hills, NJ 07934, USA</address>
> <AddressDetails Accuracy="8"
> xmlns="urn:oasis:names:tc:ciq:xsdschema:xAL:2.0"><Country><CountryName
> Code>US</CountryNameCode><CountryName>USA</CountryName><Administrative
> Area><AdministrativeAreaName>NJ</AdministrativeAreaName><SubAdministra
> tiveArea><SubAdministrativeAreaName>Morris</SubAdministrativeAreaName>
> <Locality><LocalityName>Far
> Hills</LocalityName><Thoroughfare><ThoroughfareName>2 Stanley
> Pl</ThoroughfareName></Thoroughfare><PostalCode><PostalCodeNumber>0793
> 4</PostalCodeNumber></PostalCode></Locality></SubAdministrativeArea></
> AdministrativeArea></Country></AddressDetails>    <ExtendedData>
> <LatLonBox north="40.7429886" south="40.7366934" east="-74.6749984"
> west="-74.6812936" />    </ExtendedData>
> <Point><coordinates>-74.6781460,40.7398410,0</coordinates></Point>
> </Placemark> </Response></kml>

Thanks, Art!!

There are soooo many uses and means of implementing XML in this forum that I 
find it difficult to find what I am looking for...

I will try GetChildElement (I am only looking for one and it does not 
repeat).

I guess I thought that XML had been around long enough that you could simply 
feed in the XML and execute a function like:

variable = gettext(<coordinates>).

Thanks again for your help!

Paul


"Arthur Hefti" <arthur@catsoft.ch> wrote in message 
news:4b8b4a8d@forums-1-dub...
> Paul
>
> You could use GetChildElement/GetChildElements to find the coordinates
> element. Before this function existed in PB I wrote a recursive
> function to find an element. I used GetContent to retrieve the array of
> elements of the first level, checked for type element, if found checked
> for the name of the element I'm searching. If not found, I pass the
> element to the function again.
>
> Regards
> Arthur
> -- 
>
>
>
> Paul Murray wrote:
>
>> Greetings All,
>>
>> I have an XML string that has an element called <coordinates>.
>>
>> I want to get the value of <coordinates>, but I can't seem to figure
>> out how to reference it directly.
>>
>> Below is the code for my function and the XML string...
>>
>> If someone can point me in the right direction, I would appreciate it.
>>
>> Thanks!!
>>
>> Paul
>>
>> Argument is string as 'strXML'
>> Return value is real as 'latitude'
>>
>> messagebox("The passed string is",strXML)
>>
>> real latitude
>>
>> PBDOM_Builder pbdom_bldr
>> pbdom_document pbdom_doc
>> PBDOM_OBJECT pbdom_obj_array[]
>> PBDOM_Element pbdom_elem_root
>>
>> pbdom_bldr = Create PBDOM_Builder
>> pbdom_doc = pbdom_bldr.BuildFromString(strXML)
>> pbdom_elem_root = pbdom_doc.GetRootElement()
>> boolean result
>> result = pbdom_doc.getcontent(pbdom_obj_array)
>>
>> if result <> true then
>> messagebox("Failed to getcontent",string(result))
>> else
>> messagebox("Succeeded in getting getcontent",string(result))
>> end if
>>
>>
>> string coordinates_data
>> //coordinates_data = pbdom_doc.12.gettext()
>> coordinates_data = pbdom_elem_root.GetTextNormalize()
>>
>> messagebox("coordinates_data",coordinates_data)
>>
>> messagebox("LowerBound",string(lowerbound(pbdom_obj_array)))
>> messagebox("UpperBound",string(upperbound(pbdom_obj_array)))
>>
>> integer i
>> for i = 1 to UpperBound(pbdom_obj_array)
>> messagebox("Element is",string(pbdom_obj_array[i]))
>> next
>>
>> return latitude
>>
>> XML String is:
>>
>> <?xml version="1.0" encoding="UTF-8" ?>
>> <kml xmlns="http://earth.google.com/kml/2.0"><Response>
>>  <name>2 Stanley Pl., Far Hills, NJ 07931</name>
>>  <Status>
>>    <code>200</code>
>>    <request>geocode</request>
>>  </Status>
>>  <Placemark id="p1">
>>    <address>2 Stanley Pl, Far Hills, NJ 07934, USA</address>
>> <AddressDetails Accuracy="8"
>> xmlns="urn:oasis:names:tc:ciq:xsdschema:xAL:2.0"><Country><CountryName
>> Code>US</CountryNameCode><CountryName>USA</CountryName><Administrative
>> Area><AdministrativeAreaName>NJ</AdministrativeAreaName><SubAdministra
>> tiveArea><SubAdministrativeAreaName>Morris</SubAdministrativeAreaName>
>> <Locality><LocalityName>Far
>> Hills</LocalityName><Thoroughfare><ThoroughfareName>2 Stanley
>> Pl</ThoroughfareName></Thoroughfare><PostalCode><PostalCodeNumber>0793
>> 4</PostalCodeNumber></PostalCode></Locality></SubAdministrativeArea></
>> AdministrativeArea></Country></AddressDetails>    <ExtendedData>
>> <LatLonBox north="40.7429886" south="40.7366934" east="-74.6749984"
>> west="-74.6812936" />    </ExtendedData>
>> <Point><coordinates>-74.6781460,40.7398410,0</coordinates></Point>
>> </Placemark> </Response></kml> 

On 2/03/2010 1:02 PM, Paul Murray wrote:
> Thanks, Art!!
>
> There are soooo many uses and means of implementing XML in this forum that I
> find it difficult to find what I am looking for...
>
> I will try GetChildElement (I am only looking for one and it does not
> repeat).
>
> I guess I thought that XML had been around long enough that you could simply
> feed in the XML and execute a function like:
>
> variable = gettext(<coordinates>).

you will need to roll your own to recursively find all the elements or a 
method to return the first found. Its not that hard to implement 
although it is poor on performance.

alternatively if you are in the .net world you can use the system XML 
classes and use the selectsinglenode method with xpath which makes 
finding nodes very easy and quick. I can provide some help here if you 
want to go this path.

a.


>
> Thanks again for your help!
>
> Paul
>
>
> "Arthur Hefti"<arthur@catsoft.ch>  wrote in message
> news:4b8b4a8d@forums-1-dub...
>> Paul
>>
>> You could use GetChildElement/GetChildElements to find the coordinates
>> element. Before this function existed in PB I wrote a recursive
>> function to find an element. I used GetContent to retrieve the array of
>> elements of the first level, checked for type element, if found checked
>> for the name of the element I'm searching. If not found, I pass the
>> element to the function again.
>>
>> Regards
>> Arthur
>> --
>>
>>
>>
>> Paul Murray wrote:
>>
>>> Greetings All,
>>>
>>> I have an XML string that has an element called<coordinates>.
>>>
>>> I want to get the value of<coordinates>, but I can't seem to figure
>>> out how to reference it directly.
>>>
>>> Below is the code for my function and the XML string...
>>>
>>> If someone can point me in the right direction, I would appreciate it.
>>>
>>> Thanks!!
>>>
>>> Paul
>>>
>>> Argument is string as 'strXML'
>>> Return value is real as 'latitude'
>>>
>>> messagebox("The passed string is",strXML)
>>>
>>> real latitude
>>>
>>> PBDOM_Builder pbdom_bldr
>>> pbdom_document pbdom_doc
>>> PBDOM_OBJECT pbdom_obj_array[]
>>> PBDOM_Element pbdom_elem_root
>>>
>>> pbdom_bldr = Create PBDOM_Builder
>>> pbdom_doc = pbdom_bldr.BuildFromString(strXML)
>>> pbdom_elem_root = pbdom_doc.GetRootElement()
>>> boolean result
>>> result = pbdom_doc.getcontent(pbdom_obj_array)
>>>
>>> if result<>  true then
>>> messagebox("Failed to getcontent",string(result))
>>> else
>>> messagebox("Succeeded in getting getcontent",string(result))
>>> end if
>>>
>>>
>>> string coordinates_data
>>> //coordinates_data = pbdom_doc.12.gettext()
>>> coordinates_data = pbdom_elem_root.GetTextNormalize()
>>>
>>> messagebox("coordinates_data",coordinates_data)
>>>
>>> messagebox("LowerBound",string(lowerbound(pbdom_obj_array)))
>>> messagebox("UpperBound",string(upperbound(pbdom_obj_array)))
>>>
>>> integer i
>>> for i = 1 to UpperBound(pbdom_obj_array)
>>> messagebox("Element is",string(pbdom_obj_array[i]))
>>> next
>>>
>>> return latitude
>>>
>>> XML String is:
>>>
>>> <?xml version="1.0" encoding="UTF-8" ?>
>>> <kml xmlns="http://earth.google.com/kml/2.0"><Response>
>>>   <name>2 Stanley Pl., Far Hills, NJ 07931</name>
>>>   <Status>
>>>     <code>200</code>
>>>     <request>geocode</request>
>>>   </Status>
>>>   <Placemark id="p1">
>>>     <address>2 Stanley Pl, Far Hills, NJ 07934, USA</address>
>>> <AddressDetails Accuracy="8"
>>> xmlns="urn:oasis:names:tc:ciq:xsdschema:xAL:2.0"><Country><CountryName
>>> Code>US</CountryNameCode><CountryName>USA</CountryName><Administrative
>>> Area><AdministrativeAreaName>NJ</AdministrativeAreaName><SubAdministra
>>> tiveArea><SubAdministrativeAreaName>Morris</SubAdministrativeAreaName>
>>> <Locality><LocalityName>Far
>>> Hills</LocalityName><Thoroughfare><ThoroughfareName>2 Stanley
>>> Pl</ThoroughfareName></Thoroughfare><PostalCode><PostalCodeNumber>0793
>>> 4</PostalCodeNumber></PostalCode></Locality></SubAdministrativeArea></
>>> AdministrativeArea></Country></AddressDetails>     <ExtendedData>
>>> <LatLonBox north="40.7429886" south="40.7366934" east="-74.6749984"
>>> west="-74.6812936" />     </ExtendedData>
>>> <Point><coordinates>-74.6781460,40.7398410,0</coordinates></Point>
>>> </Placemark>  </Response></kml>
>
>