[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

every 4th record increase counter

Subject: every 4th record increase counter
From: Abe Scott <abescott@xxxxxxxxx>
Date: Tue, 1 Sep 2009 07:59:17 -0700 (PDT)
 every 4th record increase counter
Greetings,

I'm
trying to create a field that will increase by 1 for every fourth
record, ordered by \CommlVeh\ItemIdInfo\SystemId  (We print 4 records
per page)  The records may be in random order and there may be missing
id's in the list.


So that my output would be similar to:

<Vehicle systemId="1" pageNum="1">
<Vehicle systemId="2" pageNum="1">
<Vehicle systemId="3" pageNum="1">
<Vehicle systemId="4" pageNum="1">
<Vehicle systemId="5" pageNum="2">
<Vehicle systemId="6" pageNum="2">    



Data Sample:

<CommlVeh id="207507" LocationRef="219009">
    <ItemIdInfo>
        <SystemId>1</SystemId>
    </ItemIdInfo>
    <Manufacturer>Make</Manufacturer>
    <Model>Model</Model>
    <ModelYear>2001</ModelYear>
    <VehBodyTypeCd>BType</VehBodyTypeCd>
    <TerritoryCd>124</TerritoryCd>
    <VehIdentificationNumber>111111</VehIdentificationNumber>
</CommlVeh>
<CommlVeh id="207509" LocationRef="219011">
    <ItemIdInfo>
        <SystemId>3</SystemId>
    </ItemIdInfo>
    <Manufacturer>Make</Manufacturer>
    <Model>Model</Model>
    <ModelYear>2001</ModelYear>
    <VehBodyTypeCd>BType</VehBodyTypeCd>
    <TerritoryCd>124</TerritoryCd>
    <VehIdentificationNumber>33333</VehIdentificationNumber>
</CommlVeh>
<CommlVeh id="207510" LocationRef="219013">
    <ItemIdInfo>
        <SystemId>5</SystemId>
    </ItemIdInfo>
    <Manufacturer>Make</Manufacturer>
    <Model>Model</Model>
    <ModelYear>2001</ModelYear>
    <VehBodyTypeCd>BType</VehBodyTypeCd>
    <TerritoryCd>124</TerritoryCd>
    <VehIdentificationNumber>5555</VehIdentificationNumber>
</CommlVeh>
<CommlVeh id="207512" LocationRef="219012">
    <ItemIdInfo>
        <SystemId>4</SystemId>
    </ItemIdInfo>
    <Manufacturer>Make</Manufacturer>
    <Model>Model</Model>
    <ModelYear>2001</ModelYear>
    <VehBodyTypeCd>BType</VehBodyTypeCd>
    <TerritoryCd>124</TerritoryCd>
    <VehIdentificationNumber>444444</VehIdentificationNumber>
</CommlVeh>
<CommlVeh id="207508" LocationRef="219010">
    <ItemIdInfo>
        <SystemId>2</SystemId>
    </ItemIdInfo>
    <Manufacturer>Make</Manufacturer>
    <Model>Model</Model>
    <ModelYear>2001</ModelYear>
    <VehBodyTypeCd>BType</VehBodyTypeCd>
    <TerritoryCd>124</TerritoryCd>
    <VehIdentificationNumber>22222</VehIdentificationNumber>
</CommlVeh>
<CommlVeh id="207511" LocationRef="219014">
    <ItemIdInfo>
        <SystemId>6</SystemId>
    </ItemIdInfo>
    <Manufacturer>Make</Manufacturer>
    <Model>Model</Model>
    <ModelYear>2001</ModelYear>
    <VehBodyTypeCd>BType</VehBodyTypeCd>
    <TerritoryCd>124</TerritoryCd>
    <VehIdentificationNumber>600007777</VehIdentificationNumber>
</CommlVeh>

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.