read first 1 to 5 records by using xsl:for-each

sus7085 · October 29th, 2010, 09:50 AM

I want to read only first five records of the xml data by xsl. By using the xsl:for-each i am able to read all the records, but my purpose is to read only first 5 records of the xml file.

XML File :
------------------------------------------------------------------------

Code:

<?xml version="1.0" encoding="ISO-8859-1"?>
<School> 
<SchoolDetails SchoolName="Name1" location="xyz1"/>
<SchoolDetails SchoolName="Name2" location="xyz2"/>
<SchoolDetails SchoolName="Name3" location="xyz3"/>
<SchoolDetails SchoolName="Name4" location="xyz4"/>
<SchoolDetails SchoolName="Name5" location="xyz5"/>
<SchoolDetails SchoolName="Name6" location="xyz6"/>
<SchoolDetails SchoolName="Name7" location="xyz7"/>
<SchoolDetails SchoolName="Name8" location="xyz8"/>
<SchoolDetails SchoolName="Name9" location="xyz9"/>
<SchoolDetails SchoolName="Name10" location="xyz10"/>
<SchoolDetails SchoolName="Name11" location="xyz11"/>
<SchoolDetails SchoolName="Name12" location="xyz12"/>
</School>

XSL:

Code:

------------------------------------------------------------------------------
<xsl:for-each select="//School/SchoolDetails"> 
<xsl:variable name="SchoolName" select="//School/SchoolDetails/@SchoolName"/>
<xsl:if test="$SchoolName">
<xsl:value-of select="//School/SchoolDetails/@SchoolName"/> 
</xsl:if>
</xsl:for-each>

spinout · October 29th, 2010, 10:34 AM

Try this...

Code:

<xsl:for-each select="//School/SchoolDetails[position() &lt; 6]">

sus7085 · October 29th, 2010, 11:07 AM

Thanks a lot.

Below code is working fine.

Code:

<xsl:for-each select="//School/SchoolDetails[position() &lt; 6]">

But in my post

Code:

<xsl:value-of select="//School/SchoolDetails/@SchoolName"/>

is pringting the 1st record for five times. But Martin Honnen
suggested that below code will print the first five records rather than printing the 1st record for 5 times.

Code:

<xsl:value-of select="@SchoolName"/>

Now i have a small problem. If the XML file is more than five records then it is fine. If the XML is having less than 5 records than i have to insert some blank values.
How i will handle that.