Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Processing an XML file to VFP cursors
Message
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Miscellaneous
Thread ID:
00904549
Message ID:
00966358
Views:
16
Don
Sorry for the delay, been away for quite some time ( too much work ).
Assuming all the "schedule" nodes are under the document element which you named loRoot, please try the following ( not tested ):
oProgramsList = loRoot.SelectNodes("schedule/@program")
oStationsList = loRoot.SelectNodes("schedule/@station") 
etc...
Tell me if it works.

Jaime

>Jamie -
>
>Thanks much for the instruction and assistance you provided in this thread. I found it highly instructive and helpful. Can you help a little more? If the XML string is formatted with the values embedded inside the tags as in:
>
>
><schedule program='EP1877110087' station='19211' time='2004-11-19T23:00:00Z' duration='PT00H30M' stereo='true' closeCaptioned='true'/>
><schedule program='EP1877110088' station='19211' time='2004-11-19T23:30:00Z' duration='PT00H30M' stereo='true' closeCaptioned='true'/>
><schedule program='EP0174130101' station='19211' time='2004-11-20T00:00:00Z' duration='PT00H30M' stereo='true' closeCaptioned='true'/>
><schedule program='EP0174130102' station='19211' time='2004-11-20T00:30:00Z' duration='PT00H30M' stereo='true' closeCaptioned='true'/>
><schedule program='MV0782170000' station='19211' time='2004-11-20T01:00:00Z' duration='PT02H00M'/>
>
>
>Is there a way to extract the values for program, station, time, etc. using the ox = createobject("MSXml.DOMDocument") object?
>
>Thanks
>- Don
Why do programs stop working correctly as soon as you leave the Fox?
Previous
Reply
Map
View

Click here to load this message in the networking platform