One of the columns in my database has charactors in it that the XML just does like. See error below. Is there any way I can tweek the information that's allowed through this process? Someone mentioned that the encoding in the DTD should be changed/altered. This is above me.
<?xml version="1.0" encoding="iso-8859-1"?>
Any help wouuld be appreciated.
<!-- MY CFC -->
<cfcomponent>
<cffunction name="entireinv" access="remote" returntype="query" output="false">
<cfset var AllInventory = 0 />
<cfquery name="AllInventory" datasource="ourdata" maxrows="954">
SELECT partno AS PART_NUMBER, pic AS PICTURE, longdesc AS LONG_DESCRIPTION, shortdesc AS SHORT_DESCRIPTION
FROM inventory
</cfquery>
<cfreturn AllInventory />
</cffunction>
</cfcomponent>
<!-- WEB SERVICE -->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<cfinvoke
webservice="http://www.oursite.com/New_Product_Submission/cfcs/InventoryDataShare.cfc?wsdl"
method="entireinv"
returnvariable="aQuery">
</cfinvoke>
<cfoutput query="aQuery">
<strong>#aQuery.currentRow#</strong> #PART_NUMBER# #PICTURE# #LONG_DESCRIPTION# #SHORT_DESCRIPTION#- <br>
<hr>
</cfoutput>
Error Occurred While Processing Request
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: &#x1d;. faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace: org.xml.sax.SAXParseException: Illegal XML character: &#x1d;. 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_test.cfm: line 19
17 : webservice="http://www.oursite.com/New_Product_Submission/cfcs/InventoryDataShare.cfc?wsdl"
18 : method="entireinv"
19 : returnvariable="aQuery">
20 : </cfinvoke>
21 :
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
