Re: First Web Service: Data Sharing

[coldfusion . developer]

It turns out that there are charactors within the long description data that contains & charactors.  I did a search on all the entries using the LIKE predicate and found 2300+ rows contain that charactor. Great! 8-)

Now I have to figure out a way to strip out the amp; out of & and leave the & without touching the the data in each record surrounding this characctor.

Does anyone know how to do this?  I'm going through all 2300 by hand. Yuk!

Thanks.

>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: &#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 :
>
>
>
>>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]
>just
>>does like.  See error below.  Is there any way I can tweek the
>>information that's allowed through this process?  Someone mentioned
>that
>y
>3
>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]

---