welcomemarie

I have problem with "How can I use xslt parse the sql command ' select DISTINCT' "?I think I already defined the SQLKeyword & template for DISTINCT, but all the other select function like "select ...where" "select...where...like.." works, except DISTINCT. I expect good solution for that. Thanks

However, I want to compare two strings come from two different .txt? I tried your proposal, but position() can't pass the value of the current node.

Can I use "<xsl:choose> <xsl:when test="string(value-of select="position()") = sting(value-of select="$sql")"> <xsl:text> The statement is valid as a success value. </xsl:text> </xsl:when> <xsl:otherwise> <xsl:text> The statement is NOT valid</xsl:text> </xsl:otherwise></xsl:choose>"I think string(value-of select="position()) is a problem. How can I test the two string are equal? Thanks

Actually, I only need the text because I have software application which can execute text like "select 'ok' where 1=1 and 2=2" directly. After the execution the result is 'OK'. But the whole process only can run one <stmnt>....</stmnt> once. I expect to see all the result of the statment. <stmnt success='ok'>select 'ok' where 1=1 and 2=2</stmnt> <stmnt success='abc'>select 'a'||'b'||'c' where 1=0 or 1=1</stmnt> <stmnt success='ok'>select 'ok' where not exists (select 'mustfail' where 1=0 and 2=0)</stmnt> Thanks!

If I have multiple XML statements, such as following:<?xml version="1.0" encoding="Windows-1252"?><statement> <stmnt success='ok'>select 'ok' where 1=1 and 2=2</stmnt> <stmnt success='abc'>select 'a'||'b'||'c' where 1=0 or 1=1</stmnt> <stmnt success='yes'>select 'ok' where not exists (select 'mustfail' where 1=0 and 2=0)</stmnt></statement>and I use xsl.copy to transform them into .fo file:"<xsl:template match="*|@*|comment()|processing-instruction()"> <xsl:apply-templates select="*|@*|comment()|processing-instruction()|te