[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Using translate() for single quotes in XSL1.0
Hi,
I am writing an XSL Transformer for SQL query and some of the column values ("ASSOCIATION_NAME") in DB might have a single quote in the name, which poses a problem in SQL. Example: <xsl:text> ... (SELECT association_id FROM ASSOCIATION WHERE association_name='</xsl:text> <xsl:value-of select='$row/sht:Cell[sht:Name="ASSOCIATION_NAME"]/sht:Content'/><xsl:text>' ) )</xsl:text>... like: "MACY'S" So I tried to use to replace 1 single quote in the column values with 2 single quotes which SQL should resolve using translate(value, "'", "''"). But there is such a mishmash of quotes and double quotes that it's impossible to resolve: ... <xsl:value-of select='translate( $row/sht:Cell[sht:Name="ASSOCIATION_NAME"]/sht:Content, '"", "'''")'/> Any way around it, maybe via ASCII of single quotes ?
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|