Hi all,

Please can someone help me with this problem.

I am trying to use the position() function to filter the records of a given record set. I basically want to split the records into groups of 14,990

It appears to always return the first 14990 no matter what values are in the xslt.

Here's my xslt:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output method="xml" />
<xsl:template match="DATA">
<STOCK>
<xsl:for-each select="ROW">
<xsl:if test="(position() &gt; 14990 and position() &lt; 29980) and SiteID = '00020' ">
<VEHICLE>
<ADVREF>
<xsl:value-of select="VehicleID" />
</ADVREF>
<CAPTYPE />
<MANUFACTURER>
<xsl:value-of select="Manufacturer" />
</MANUFACTURER>
<MODEL>
<xsl:value-of select="Range" />
</MODEL>
<CAPID>
<xsl:value-of select="CAP_ID" />
</CAPID>
<DERIVATIVE />
<BODYTYPE />
<FUELTYPE />
<DOORS />
<TRANSMISSION />
<DESCRIPTION>
<xsl:value-of select="Description" />
</DESCRIPTION>
<DEEPLINK>
<xsl:value-of select="DeepLink" />
</DEEPLINK>
<FINANCETYPE>
<xsl:value-of select="FinanceType" />
</FINANCETYPE>
<DEPOSITTYPE>
<xsl:value-of select="DepositType" />
</DEPOSITTYPE>
<DEPOSITVALUE>
<xsl:value-of select="DepositValue" />
</DEPOSITVALUE>
<TERM>
<xsl:value-of select="Term" />
</TERM>
<PAYMENTS />
<MONTHLYPAYMENT>
<xsl:value-of select="MonthlyPayment" />
</MONTHLYPAYMENT>
<ANNUALMILEAGE>
<xsl:value-of select="AnnualMileage" />
</ANNUALMILEAGE>
<MAINTENANCETYPE>
<xsl:value-of select="MaintenanceType" />
</MAINTENANCETYPE>
<MAINTENANCEVALUE>
<xsl:value-of select="MaintenanceValue" />
</MAINTENANCEVALUE>
<INSTOCK>
<xsl:value-of select="InStock" />
</INSTOCK>
<DOCUMENTFEE>
<xsl:value-of select="DocumentFee" />
</DOCUMENTFEE>
<CAPCODE />
<AUTORENEW>
<xsl:value-of select="AutoRenew" />
</AUTORENEW>
<CO2 />
</VEHICLE>
</xsl:if>
</xsl:for-each>
</STOCK>
</xsl:template>
</xsl:stylesheet>

Can't see anything obviously wrong. Please try to reduce it to a simpler example (fewer rows, less data in each row) that illustrates the problem, and then post complete XML and XSLT code so we can run it ourselves.

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference

Are there any records with a SiteID of '00020' in that range of records?

Try perhaps adding that clause separately to the xsl:for-each (you could actually add both to this instruction):

Sam

__________________
/- Sam Judson : Wrox Technical Editor -/

Think before you post: What have you tried?