Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XML Parse problem - invalid character
Message
From
04/10/2006 10:54:13
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
XML Parse problem - invalid character
Miscellaneous
Thread ID:
01159360
Message ID:
01159360
Views:
76
I admit up front, I don't have a lot of experience with XML. I have an XML file I generated by CursorToXML(), which went fine, but when I take the same file and try to convert it back to a cursor I get this parsing error.
XMLTOCURSOR([c:\crap\statemnt.xml],[mystmt],512)
XML Parse error: An invalid character was found in text content.
 Line 40199, Position 42.   		<desc>NW/4 SECTION 20, BLOCK 44, T-1N,
*right here shows an unprintable char**  T & P, RR CO SURVEY, ECTOR COUNTY, TEXAS                           
I did not encase memo fields in CDATA sections, though I may want to do that. I believe I need to pre-process memo fields to clean them up before creating XML. What I want to know is what characters doesn't the parser like? I doubt tabs, and CRLF's cause any problem for it. I guess I could STRTRAN() the memo field's of anything CHR(1) - CHR(31), but I'd like to only do the minimal needed modifications.

Any help is always appreciated.
Jim Newsom
IT Director, ICG Inc.
Next
Reply
Map
View

Click here to load this message in the networking platform