"aServiceSummaryArray" is the returned variable from web service that holds the xml data before it is parsed.
<cfset a1=replace(aServiceSummaryArray,"&##x12;","","ALL")>
<cfset a2=replace(a1,"&##x15;","","ALL")>
<cfset a3=replace(a2,"&##x5;","","ALL")>
<cfset a4=replace(a3,"&##x17;","","ALL")>
>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 "&" and
>replaced it with "and". I run a query against the table and ask it to show
>me
>all instances of "&" 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: . faultActor: faultNode: faultDetail:
>{http://xml.apache.org/axis/}stackTrace: org.xml.sax.SAXParseException:
>Illegal XML character: . 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]
