Based on the AxisFaultCode, I believe that the actual character you want to
replace is represented by the entity &x1c;


Assuming that in CF the variable xmlcontent holds the xml document, then the
following would strip that character out:
<cfset xmlcontent = replace(xmlcontent,chr(28),'','all')>


xmlformat() only escapes five characters by replacing them with their known
entities, including the characters: > < & ' "


-Steve

  _____  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, August 20, 2004 2:31 PM
To: CF-Talk
Subject: Frustrated: Help Web Services - Illegal XML character

I'm sharing data from our database through remote Web Services. This one
column with long product description is causing the following error.  I've
written an TSQL script that when in and removed all instances of "&amp;" and
replaced it with "and".  I run a query against the table and ask it to show
me
all instances of "&amp;" and it comes back with no results.  Great!  However
I'm still getting this error that say there's an illegal charactor.

I'm using XMLFORMAT() already and still ...  any help would be great.

Thanks.

Could not perform web service invocation "entireinv" because AxisFault
faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
faultSubcode: faultString: org.xml.sax.SAXParseException: Illegal XML
character: &amp;#x1c;. faultActor: faultNode: faultDetail:
{http://xml.apache.org/axis/}stackTrace: org.xml.sax.SAXParseException:
Illegal XML character: &amp;#x1c;. at
org.apache.crimson.parser.InputEntity.fatal(InputEntity.java:1100) at
org.apache.crimson.parser.InputEntity.parsedContent(InputEntity.java:593) at
org.apache.crimson.parser.Parser2.content(Parser2.java:1973) at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1654) at
org.apache.crimson.parser.Parser2.content(Parser2.java:1926) at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1654) at
org.apache.crimson.parser.Parser2.content(Parser2.java:1926) at
org.apache.crimson.parser.Parser2.maybeElement(Parser2.java:1654) at
org.apache.crimson.parser.Parser2.content(Parser2.java:1926) at
org.apache.crimson.parser.Parser2.maybeElement(Par...

The error occurred in
D:\Inetpub\wwwroot\New_Product_Submission\Web_Services\Inventory_test2.cfm:
line 14

12 :
webservice="http://www.toolweb.com/New_Product_Submission/cfcs/InventoryData
Share2.cfc?wsdl"
13 :  method="entireinv"
14 :  returnvariable="aQuery">
15 : </cfinvoke>
16 :
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to