RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???)

[Luca Morandini]

> -----Original Message-----
> From: Delis, Christopher E. [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 18, 2003 6:32 PM
> To: '[EMAIL PROTECTED]'
> Subject: RE: sql transformer question; *not* esql... (was RE: ???ESQL
> upda te table???)
> 
> 
> do you mind sharing the template? =-)  --chris

not at all (mind, it just converts single quotes in double-single quotes).

        <xsl:template name="escape-apos">
                <xsl:param name="string" />

                <xsl:choose>

                <xsl:when test='contains($string, "&apos;")'>

                        <xsl:value-of select='substring-before($string, "&apos;")' />
                        <xsl:text>''</xsl:text>

                        <xsl:call-template name="escape-apos">
                        <xsl:with-param name="string" select='substring-after($string, 
"&apos;")' />
                        </xsl:call-template>

                </xsl:when>

                        <xsl:otherwise>
                        <xsl:value-of select="$string" />
                </xsl:otherwise>

                </xsl:choose>

        </xsl:template>

Regards,

--------------------------------------------- 
               Luca Morandini 
               GIS Consultant 
              [EMAIL PROTECTED] 
http://utenti.tripod.it/lmorandini/index.html 
---------------------------------------------
 


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]