| 
		
 | 
	| 
		
 | 
	
		
		
			| Re: How to generate XSL file from table data [message #400941 is a reply to message #400894] | 
			Thu, 30 April 2009 08:27    | 
		 
		
			
				
				
				
					
						
						Orna
						 Messages: 62 Registered: November 2008 
						
					 | 
					Member  | 
					 | 
		 
		 
	 | 
 
	
		Thank you for looking into this, Frank. 
 
XSL should look like: 
 
<?xml version="1.0" encoding="UTF-8" ?> 
- <xsl:stylesheet version="2.0" 
xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
xmlns:xs="http://www.w3.org/2001/XMLSchema" 
xmlns:fn="http://www.w3.org/2005/xpath-functions"> 
<xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes" 
/> 
- <xsl:template name="DomainLookup"> 
<xsl:param name="domainId" /> 
<xsl:param name="domainCode" /> 
- <xsl:if test="$domainId = 'GNLSTSTS'"> 
- <xsl:if test="$domainCode = 'N'"> 
<xsl:text disable-output-escaping="yes">Active</xsl:text> 
</xsl:if> 
- <xsl:if test="$domainCode = 'P'"> 
<xsl:text disable-output-escaping="yes">Pending</xsl:text> 
</xsl:if> 
</xsl:if> 
</xsl:template> 
</xsl:stylesheet>  
 
The table contains domain data: 
 
DOMAIN_CODE	 
CODE_VALUE				 
 
There is no PK, for the same domain code there will be many CODE_VALUE values. 
 
		
		
		
 |  
	| 
		
	 | 
 
 
 | 
	| 
		
 |