In the row that bombs, what does the data look like?

  _____  

From: [EMAIL PROTECTED] [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Thursday, July 22, 2004 1:04 PM
To: CF-Talk
Subject: Re: First Web Service: Data Sharing

I applied it here ...

<!-- WEB SERVICE -->
<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> #xmlformat(PART_NUMBER)# - <br>
<hr>
</cfoutput>

AND I STILL GET THIS ERROR.

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: &amp;#x1d;. faultActor: faultNode: faultDetail:
{http://xml.apache.org/axis/}stackTrace: org.xml.sax.SAXParseException:
Illegal XML character: &amp;#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 :

>Have you tried using the XMLFormat() function?
>
>http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/funca123.htm#wp4
5
>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/Inventor
y
>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:59
3
>) 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.c
f
>m: line 19
>
>17 :
>webservice="http://www.oursite.com/New_Product_Submission/cfcs/Inventor
y
>DataShare.cfc?wsdl"
>18 :  method="entireinv"
>19 :  returnvariable="aQuery">
>20 : </cfinvoke>
>21 :
>  _____
  _____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

Reply via email to