Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Illegal character
Message
 
To
04/11/2004 08:06:26
General information
Forum:
Visual FoxPro
Category:
XML, XSD
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00958028
Message ID:
00958046
Views:
18
Tore,

in code:
FUNCTION showproducts
loXMLAdapter = CREATEOBJECT("XMLAdapter")

SELECT prcode, prchemdesc, prregion;
FROM product;
WHERE SUBSTR(prInternet,1,1) = 'Y';
	AND (EMPTY(prStatus) OR ISNULL(prStatus));
INTO CURSOR curProducts READWRITE

loXMLAdapter.AddTableSchema("curProducts")
loXMLAdapter.UTF8Encoded = .T.
loXMLAdapter.ToXML("lcXMLData")
			
RETURN lcXMLData
Regards,
Ron

>How do you create the xml-string?
>
>>I have created a small vfp-com dll that returns data as an xml-string. This works fine. However, if I return the string on a webpage I get the following message:
>>Error: An invalid character was found in text content (in a dialog)
>>
>>When the string is shown in the browser you see the following:
>>The XML page cannot be displayed
>>Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.
>>
>>Taking a close look into the string itself it is refering to the µ (greek-micro) character.
>>
>>I could remove this character but are the any more such characters that will give this problem. Is it possible to replace this character with an xml-allowed variant. Why can VFP generate this xml if it is not what Internet Explorer likes to have.
>>
>>Thanks in advance,
>>
>>Ron
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform