XSLT for XML to Text

navik_pathak · July 9th, 2009, 05:22 PM

Hi Guys,

Need your help on following....

I have following XML which i want to covert it as Text with Numbering added to it.

Code:


<?xml version="1.0"?>
<ROWSET>
<ROW>
<ERROR_MESSAGE>Error</ERROR_MESSAGE>
</ROW>
<ROW>
<ERROR_MESSAGE>Error</ERROR_MESSAGE>
</ROW>
<ROW>
<ERROR_MESSAGE>Error</ERROR_MESSAGE>
</ROW>
</ROWSET>

XSLT code

Code:


<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>
<xsl:template match="ROWSET">
<xsl:apply-templates select="ROW"/>
</xsl:template>
<xsl:variable name="ItemIndex" select="0"/>
<xsl:template match="ROW">
<xsl:for-each select="*">
<xsl:variable name="pos" select="position()"/><xsl:value-of select="$ItemIndex[$pos]"/>
<xsl:value-of select="."/>
</xsl:for-each>
<xsl:text>
</xsl:text>
</xsl:template>
</xsl:stylesheet>

Using XSLT on above XML ...i am getting following output...

0Error
0Error
0Error

desired output...
1Error
2Error
3Error

thanks in advance for pointing out the error in my XSLT...

mhkay · July 9th, 2009, 07:12 PM

Well, each ROW has one element child, so the for-each select="*" selects one node, and the position of that node is always 1. So $pos is always 1. $ItemIndex is a sequence of integers of length 1 (specifically, a singleton integer whose value is zero), so $ItemIndex[$pos] is the first integer in this sequence, which is zero. I've no idea what you had in mind when you wrote this code.

Try:

Code:

<xsl:template match="ROW">
  <xsl:number/>
  <xsl:value-of select="ERROR_MESSAGE"/>
</xsl:template>

navik_pathak · July 9th, 2009, 07:17 PM

Quote:

Originally Posted by mhkay

Well, each ROW has one element child, so the for-each select="*" selects one node, and the position of that node is always 1. So $pos is always 1. $ItemIndex is a sequence of integers of length 1 (specifically, a singleton integer whose value is zero), so $ItemIndex[$pos] is the first integer in this sequence, which is zero. I've no idea what you had in mind when you wrote this code.

Try:

Code:

<xsl:template match="ROW">
  <xsl:number/>
  <xsl:value-of select="ERROR_MESSAGE"/>
</xsl:template>

Thanks mhkay..newbie to coming to begginer level...overthinking ....so i did that mistake....your solution worked perfactly...