Solved

xslt pagination

Posted on 2011-09-19
5
359 Views
Last Modified: 2013-11-18
Hi,

I  have some very simple XSLT that I have created, displaying an XML feed nicely.
However, this XML feed can contant hundreds of records so I need to add some pagination to ensure it stays tidy. However, I have no idea where to start.

Any help would be great.

Attached is a snippet of the XML structure.
If you would like my XSLT then I can post that too.

Thanks
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Root>
 <Product Page_Nr="41">¿    
  <Story>¿
   <ServiceName>Test Name</ServiceName>
   <Product_Rating>5</Product_Rating>¿
   <Desc_Destinations>Test Desc</Desc_Destinations>¿
  </Story>
  <Story>
   <Desc_Snapshot>Blah blah blah</Desc_Snapshot>¿
   <Desc_Hotel_Facilities>test facilities</Desc_Hotel_Facilities>¿
   <Desc_Guest_Rooms>92 Rooms • Balcony • Fully equipped kitchen • Air-con • TV • Hairdryer • Iron and ironing board</Desc_Guest_Rooms>¿
   <Price>£118</Price>
   <Desc_Price_description>Superior Suite (Room Only)</Desc_Price_description>¿
  </Story>¿
  <Image_1 href="hotel-image.jpg"></Image_1>¿  </Product>
</Root>

Open in new window

0
Comment
Question by:help-is-needed
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 36560911
Pagination is just a matter of cutting the page, so usually the XSLT is not very difficult.
You need to pass a parameter to the XSLT that tells you which should be your first record to show, and how many records you want to show.

Rest depends on the (web) architecture you are using

Basically I need more detail.
How do you run the XSLT
And how do you expect this to happen?

Is this static HTML calling an XSLT on an input XML... then javascript and eg. sarissa could do magic
Do you have ASP? Something else

Paging is a piece of cake, but you need to tell us what you want to happen.
0
 

Author Comment

by:help-is-needed
ID: 36561006
Hi Gertone,

Thanks for getting back to me.
I am not using ASP. But probably using HTML to call an XSLT on an XML input then javascript to do the transformation.

Can you show me an example of this working?

Thanks
0
 
LVL 60

Accepted Solution

by:
Geert Bormans earned 500 total points
ID: 36565580
This should get you started

Make sure that you have a function showPage() in your javascript
that takes two parameters (integers, the first Record and the number of records)
and that does the transform passing the two integer parameters to the XSLT

Of course you could easily add extra navigation, I did a naieve "previous" and "next"
but it is fairly simple to add a "first" and "last"
<?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="1.0">
    <xsl:param name="first">4</xsl:param>
    <xsl:param name="size">8</xsl:param>
    
    <xsl:template match="Root">
        <div>
            <xsl:apply-templates select="Product[position() >= $first and position() &lt; $first + $size]"/>
            <xsl:call-template name="navigation"/>
        </div>
    </xsl:template>
    
    <xsl:template match="Product">
        <!-- do product stuff here -->
        <p><xsl:value-of select="Story[1]/ServiceName"/></p>
    </xsl:template>
    
    <xsl:template name="navigation">
        <div>
            <a href="_blank">
                <xsl:attribute name="onclick">
                    <xsl:text>showPage(</xsl:text>
                    <xsl:value-of select="$first - $size"/>
                    <xsl:text>,</xsl:text>
                    <xsl:value-of select="$size"/>
                    <xsl:text>);</xsl:text>
                </xsl:attribute>
                <xsl:text>previous</xsl:text>
            </a>
            <xsl:text>   </xsl:text>
            <a href="_blank">
                <xsl:attribute name="onclick">
                    <xsl:text>showPage(</xsl:text>
                    <xsl:value-of select="$first + $size"/>
                    <xsl:text>,</xsl:text>
                    <xsl:value-of select="$size"/>
                    <xsl:text>);</xsl:text>
                </xsl:attribute>
                <xsl:text>next</xsl:text>
            </a>
        </div>
    </xsl:template>
    
</xsl:stylesheet>

Open in new window

0
 

Author Comment

by:help-is-needed
ID: 36565829
Thanks Gertone,

I've downloaded the sarissa package and managed to write some js that is working.
Thanks for your help, very simple when you know how.

Thanks
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 36565837
welcome
0

Featured Post

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Many times as a report developer I've been asked to display normalized data such as three rows with values Jack, Joe, and Bob as a single comma-separated string such as 'Jack, Joe, Bob', and vice versa.  Here's how to do it. 
JavaScript has plenty of pieces of code people often just copy/paste from somewhere but never quite fully understand. Self-Executing functions are just one good example that I'll try to demystify here.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to count occurrences of each item in an array.
Suggested Courses

617 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question