Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to convert complex XML to Cursor
Message
 
À
13/04/2005 20:20:08
Information générale
Forum:
Visual FoxPro
Catégorie:
XML, XSD
Versions des environnements
Visual FoxPro:
VFP 7
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01004436
Message ID:
01005590
Vues:
12
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform