http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funca123.htm#wp45
69342
_____
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 22, 2004 9:29 AM
To: CF-Talk
Subject: First Web Service: Data Sharing
All,
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/Inventory
DataShare.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.cf
m: line 19
17 :
webservice="http://www.oursite.com/New_Product_Submission/cfcs/Inventory
DataShare.cfc?wsdl"
18 : method="entireinv"
19 : returnvariable="aQuery">
20 : </cfinvoke>
21 :
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
