XML attributes into cursor

I need to pull both data and attributes into a VFP cursor. XMLTOCURSOR works
fine with this XML:

<item code="xyz">
<data date="20040805">AAAAAA</data>
</item>

but the cursor only contains the field "data" with the value "AAAAAA". I
need to also includes the "code" field and the "date" field into the cursor.

Is this possible either with XMLTOCURSOR or XMLAdapter?
--
seeker

Sietse
Fri Aug 06 01:24:08 CDT 2004

Hi Seeker,
The result that you want from the xml is not designed in XMLTOCIRSOR nor in
the XMLAdapter.
If you want the result as described from this XML, you'' lave to do it
yourself using STREXTRACT() or a XML-parser (like MSXML DOMDocument or the
SAXParser)

HTH,
Sietse Wijnker

"seeker" <seeker@discussions.microsoft.com> wrote in message
news:445B21B2-6C3A-464B-920F-736E4AC08491@microsoft.com...
> I need to pull both data and attributes into a VFP cursor. XMLTOCURSOR
works
> fine with this XML:
>
> <item code="xyz">
> <data date="20040805">AAAAAA</data>
> </item>
>
> but the cursor only contains the field "data" with the value "AAAAAA". I
> need to also includes the "code" field and the "date" field into the
cursor.
>
> Is this possible either with XMLTOCURSOR or XMLAdapter?
> --
> seeker