XSLT Issue with Apostrophes

Avatar

Avatar

Ryan_Lunka

Avatar

Ryan_Lunka

Ryan_Lunka

30-04-2009

I have a service that reads information from a database and uses the Query Database for Multiple Rows to XML component.  The next step in the service is an XSLT that essentially removes all the type="VARCHAR" attributes that the component adds.

We began running live data through and now the XSLT is erroring out because some of the values that get queried contain apostrophes and the XSL component won't read it correctly.  Is there anything I can do in the XSL Stylesheet to get allow it figure out that?

Any suggestions?

Thanks for any help!

View Entire Topic

Avatar

Avatar

HowardTreisman

Avatar

HowardTreisman

HowardTreisman

01-05-2009

Hi Ryan

You may want to preprocess the results to turn these characters into their XML "escaped" equivalents.

e.g.      ' for '

See http://www.xmlnews.org/docs/xml-basics.html

We also have a SQPlus component that does what the Adobe component does, plus quite a bit more. We'd be happy to talk to you about adding a facility into that for automatically escaping non-allowed characters.

If you'd like to explore this option, please contact me at htreisman-at-avoka.com

Howard