David - I just responded to book mark the thread. I have to walk the dog and do some yard work. I will try to post an MSXML script after I finish!
>I need to get a complex xml document into a usable VFP table/cursor. Here is a sample:
>
>
><?xml version="1.0" encoding="UTF-8"?>
><!DOCTYPE cXML SYSTEM "http://xml.cXML.org/schemas/cXML/1.2.007/cXML.dtd">
><cXML payloadID="f1ab6595000001033d05d59300019c18@nowhere.com" timestamp="2005-04-13T12:25:22-07:00" xml:lang="en-US">
> <Response>
> <Status code="401" text="Unauthorized">Incoming are invalid</Status>
> </Response>
></cXML>
>
>
>This sample has both elements and attributes. I don't know how to get the attributes imported w/o writing my own xml2cursor parser. Is there something that I can use that will accomplish this for me?
>
>I have tried XMLtoCursor() and it only gives me the Status data, not the code or the text. Even when I redirect to an existing cursor, with code and text fields, they are not converted.
>
>David
Imagination is more important than knowledge