Problem with displaying data

utyk · October 29th, 2009, 02:05 PM

Hello Everyone

I am dispalying XML data using XSLT I want to display data from 'address' element first and then 'name' element. But the problem is its displaying data from 'name' element first then from 'address'.

below is the code for your view :

XML Document :

Code:

<?xml version="1.0" encoding="UTF-8"?>


  <employees>
	<employee>
           <name>
            <firstname>peter</firstname>
            <lastname>Dossan</lastname>
	   </name>
	   <address>
		<street>purly</street>
		<state>MH</state>
		<zip>4009890</zip>
           </address>	
	</employee>
  </employees>

XSLT :

Code:

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" 
      xmlns:xs="http://www.w3.org/2001/XMLSchema"
      exclude-result-prefixes="xs"
      version="2.0">
    
        
    <xsl:template match="/">
        
        <xsl:apply-templates/>       
        
    </xsl:template>
    
        
    <xsl:template match="address">                 
                          
	 <xsl:value-of select="street"></xsl:value-of>
         <br />

         <xsl:value-of select="state"></xsl:value-of>
	 <br/>	

	<xsl:value-of select="zip"></xsl:value-of>
	 <br/>		

        
    </xsl:template>


    <xsl:template match="name">                 
                          
	 <xsl:value-of select="firstname"></xsl:value-of>
         <br />

         <xsl:value-of select="lastname"></xsl:value-of>
	 <br/>

	
        
    </xsl:template>

</xsl:stylesheet>

how can i achieve that ?

Thanks for your help

yanki

Martin Honnen · October 29th, 2009, 02:11 PM

Replace

Code:

    <xsl:template match="/">
        
        <xsl:apply-templates/>       
        
    </xsl:template>

with

Code:

    <xsl:template match="/">
        
        <xsl:apply-templates select="employees/employee/address, employees/employee/name"/>       
        
    </xsl:template>

utyk · October 29th, 2009, 03:44 PM

Thanks martin its working.

I have a quick question.

In XML i have element like below :

[code]

<departments>
<department>Sales</department>
<department>Marketing</department>
<department>Finance</department>

</departments>

[code]

Code:

<xsl:template match="departments" 
        <tr>
            <td colspan="3">
                <marquee><xsl:value-of select="department"/> <xsl:text>  </xsl:text> <xsl:text>  </xsl:text></marquee>                
            </td>
        </tr>        
    </xsl:template>

I want 3 white space between department values.
How can i do that ?

Thanks again

yanki

mrame · October 30th, 2009, 02:17 AM

Try the below:

<xsl:template match="departments">
<tr>
<td colspan="3">
<marquee>
<xsl:for-each select="department">
<xsl:value-of select="."/>
<xsl:if test="not(position() = last())">
<xsl:text> </xsl:text>
<xsl:text> </xsl:text>
<xsl:text> </xsl:text>

</xsl:if>
</xsl:for-each>
</marquee>
</td>
</tr>
</xsl:template>

mhkay · October 30th, 2009, 05:50 AM

If you are using XSLT 2.0 then

Code:

<xsl:value-of select="department" separator="   "/>

will display all the departments, with three spaces between adjacent departments. (Of course if this is generating HTML, you probably want three non-breaking spaces instead.)