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/InventoryDataShare2.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