xsl-list
[Top] [All Lists]

[xsl] Using translate() for single quotes in XSL1.0

2006-08-25 13:12:19
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 ?


Thank you in advance,
Oleg.

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--