Backward Navigation Problem

Play the video

Subject: Backward Navigation Problem
From: Anil Kumar Veeramalli <anil.v@xxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 02 Nov 2009 15:00:15 +0530

Hi,

My sample XML file lok lilke this <root> <employees> <employee hireDate="04/23/1999"> <COLUMN NAME="LAST">Hilllfrist</COLUMN> <COLUMN NAME="STATUS"><![CDATA[A]]></COLUMN> </employee> <employee hireDate="05/23/1999"> <COLUMN NAME="LAST">raj</COLUMN> <COLUMN NAME="STATUS"><![CDATA[T]]></COLUMN> </employee> </employees> <TABLE NAME="XLATTABLE_EMPL_STATUS"> <ROWS> <ROW> <COLUMN NAME="STATUS"><![CDATA[T]]></COLUMN> <COLUMN NAME="DESCR"><![CDATA[Terminated]]></COLUMN> </ROW> <ROW> <COLUMN NAME="STATUS"><![CDATA[A]]></COLUMN> <COLUMN NAME="DESCR"><![CDATA[Active]]></COLUMN> </ROW> <ROW> </TABLE > </root>

I need to Iterate all the Status values and need to fetch the description from XLATTABLE_EMPL_STATUS.

Example if the status is A, it has to be displayed as Active, if its T , it has to be displayed as Terminated.

My xsl code is as below.

xsl:template match="root"> <xsl:for-each select="employees"> <xsl:for-each select="employee"> <xsl:if test="@NAME='STATUS'"> <xsl:variable name="status" select="."/> <xsl:for-each select="TABLE[@NAME='XLATTABLE_EMPL_STATUS']/ROWS/ROW/COLUMN[@NAME='STATUS']"> <xsl:value-of select="TABLE[@NAME='XLATTABLE_EMPL_STATUS']/ROWS/ROW/COLUMN[@NAME='DESCR']" </xsl:for-each>

</xsl:if>

   </xsl:for-each>
</xsl:for-each>
</xsl:template>

looks like TABLE[@NAME='XLATTABLE_EMPL_STATUS']/ROWS/ROW/COLUMN[@NAME='STATUS']" is not working.

Approaches I followed. 1) ../TABLE[@NAME='XLATTABLE_EMPL_STATUS']/ROWS/ROW/COLUMN[@NAME='STATUS']" 2) parent::node()/TABLE[@NAME='XLATTABLE_EMPL_STATUS']/ROWS/ROW/COLUMN[@NAME='DESCR']

Please suggest me on this.


Thanks,
Anil

Current Thread
Backward Navigation Problem Anil Kumar Veeramalli - 2 Nov 2009 09:30:50 -0000 <= Mukul Gandhi - 2 Nov 2009 10:11:26 -0000 Michael Kay - 2 Nov 2009 10:18:53 -0000 Anil Kumar Veeramalli - 2 Nov 2009 10:53:28 -0000 Mukul Gandhi - 2 Nov 2009 10:59:41 -0000

<- Previous	Index	Next ->
XSL-List Guidelines, Mulberry Technologie	Thread	Re: Backward Navigation Probl, Mukul Gandhi
XSL-List Guidelines, Mulberry Technologie	Date	Re: Backward Navigation Probl, Mukul Gandhi
	Month

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

RSS 2.0
Atom 0.3


	Stylus Studio® Developer Network \| Contact Us \| Email this page