CFCOMPONENT/CFINVOKE: Help

Help I'm using a CFC to create a Web service. One of the columns in my query past through the Web service has HTML tags in the ntext data type column.  The Web Service doesn't like it and throws an error for just this column. I think the markup needs to be stripped from the data and then I think the data needs to be normalized.  I woul create another table called long description and relate each record back to this original table primary id. Agree? Disagree? RECORD EXAMPLE 1: <b>C61</b><p>Combo Coupler 1/4in Series 1/4in NPT Male<br><br>The Solution for Coupler Confusion. Now One coupler Fits 1/4" Aro Style, 1/4" Automotive Standard and 1/4" Industrial Interchange Plugs. RECORD EXAMPLE 2: '<p><b>A750FD25</b></p> <p>Blue Flexeel Air Hose 3/8" x 25', 1/4" MPT</p> <p><b>Features & Benefits:</b><br> </p> <ul> <li>Retains flexibility in subzero temperatures</li> <li>UV stabilized for longer outdoor service life</li> <li>Easy to wrap & store</li> <li>Resistant to lubricating oils, greases & abrasion</li> </ul><p><b>Flexeel^R</b> Polyurethane Reinforced Hose offers an excellent alternative to bulkier rubber hoses.  It is extremely lightweight and tough.  Ideal for either indoor body shop use or outsdoor road service, it keeps its flexibility even in very cold environments.  Its reinforced construction eliminates the possibility of having the various layers separate due to constant expansion and contraction during pulsating operations.<p> RECORD EXAMPLE 3: BRN<br><br>Torq Bar 13/16in-100 Ft Lb Brown

What error are you getting exactly? You should have no problem returning a string w/ HTML in it.

>What error are you getting exactly? You should have no problem returning a >string w/ HTML in it. Error Occurred While Processing Request   Could not perform web service invocation "myFunction" 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 14 12 :  webservice="http://www.toolweb.com/New_Product_Submission/cfcs/InventoryDataShare.cfc?wsdl" 13 :  method="myFunction" 14 :  returnvariable="aQuery"> 15 : </cfinvoke> 16 :

Ah, I now seem to remember running into this when building a RSS feed for the blog. You could use XMLFormat() on the data. Since you have a query though you would have to loop over the query and use querySetCell() to update each item.

At 11:48 AM 5/18/2004, you wrote: ----- Excess quoted text cut - see Original Post for more ----- You could encode the HTML text, but then you'll have to escape your entities.

>At 11:48 AM 5/18/2004, you wrote: > >You could encode the HTML text, but then you'll have to escape your entities. Not sure how to do that.  Can you please give me a quick example. Thanks.