Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Illegal character
Message
From
04/11/2004 09:08:51
 
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:
00958054
Views:
17
Hello again,

reading your code, I don't immediately see any errors. However, in my work we use the micro-sign (µ) a lot, but we always print u. Unless someone give you a fix, I suggest you use a chrtran(yourtext,'µ','u') as an emergency fix.

>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
Reply
Map
View

Click here to load this message in the networking platform