Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XML parsing problem involving quotes
Message
From
21/12/2005 11:10:35
Mike Sue-Ping
Cambridge, Ontario, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
XML parsing problem involving quotes
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01079885
Message ID:
01079885
Views:
76
Hi All,

I have a string of XML that I'd like to load into an XMLAdapter. I can do this most of the time by calling the latter's LoadXML() method and passing in the XML string. Occasionally, the method causes an error because the XML string contains single quote delimited values that can contain an apostrophe. This throws off the balance of quotes. Here's an example snippet:
<rs:data>
<z:row LandStreetNum='1000' LandStreetName='Richard's St'... />
</rs:data>
Note how Richard's St messes up the quotes.

Is there any way to tell the XMLAdapter to substitute double quote "delimiters" for single quotes when it tries to LoadXML()? Of course it has to ignore the apostrophe too :)

TIA

Mike
Next
Reply
Map
View

Click here to load this message in the networking platform