Solved

xslt pagination

Posted on 2011-09-19
5
346 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
  • 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

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Mongodb hierarchy 2 59
Problem to ToolkitScriptManager 2 67
XSL - change date format 3 49
What language/protocol is the Angular Chat? 2 85
Preface This article introduces an authentication and authorization system for a website.  It is understood by the author and the project contributors that there is no such thing as a "one size fits all" system.  That being said, there is a certa…
Preface In the first article: A Better Website Login System (http://www.experts-exchange.com/A_2902.html) I introduced the EE Collaborative Login System and its intended purpose. In this article I will discuss some of the design consideratio…
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

860 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