XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » problem with sorting table contents based on randomly selected header
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + how to insert un return in the... (2)
-> + String in a range (5)
-> + To identify the right edition (4)
-> + Flow Control Feature (2)
-> + calling nested external functi... (3)
-> + Replacing commas with a blank (6)
-> + Grouping very urgent . (2)
-> + xsl node number (3)
-> + Wordml intelligence (6)
-> + Preview and backmapping for wo... (5)
-> + XSLT - find line numbers of di... (2)
-> + The last five bytes of a varia... (7)
-> + simple problem but i'm a bit t... (3)
-> + H plz help me (2)
-> + XSLT : Very Urgent Requirement (7)
-> + comparing two xml files (3)
-> + Support for xsl created from w... (4)
-> + Wildcard Param (3)
-> + XSLT OutOfMemoryError (3)
-> + How can I output the filename ... (7)
-> + How do I strip out a comma ast... (8)
-> + xslt current-dateTime() not re... (2)
-> + Exceed the maximum recursion d... (8)
-> + Saxon9 "java.net.ConnectExcept... (2)
-> - Help Required (1)
-> + XSLT Help to get value from Up... (2)
-> + Date Functions (5)
-> + Need to unescape < and > (2)
-> + No Topic (2)
-> + Problem with handling multiple... (3)
-> + Question XPath expression (dis... (2)
-> + New user, basic question (2)
-> + Serializing XML to a string wi... (2)
-> + Node already has a control li... (2)
-> + Trying to access the position ... (5)
-> + XSLT Help (2)
-> + XSLT, Microsoft Access, and re... (4)
-> + saxon:assign usage problem. (5)
-> + Help with XSLT mapping require... (4)
-> + Muenchian Grouping problem (6)
-> + Automatic postprocessing (2)
-> + Problem Setting Variable (3)
-> - Problem Setting Variable (1)
-> + Looping question (14)
-> + Attribute Centeric XML from Re... (2)
-> + How do I do this ? (2)
-> + Accessing an attribute based o... (3)
-> + help needed - using saxon thro... (2)
-> + Grouping Problem still (6)
-> + Use XSL-FO to create tables fr... (6)
-> + taking out a child and (6)
-> + Yet another problem (3)
-> + using XSL-FO to convert PDF (4)
-> + Preventing namespace declarati... (2)
-> + Small problem during conversio... (4)
-> + Problems removing namespaces (2)
-> + Grouping/Following question (4)
-> + Transforming XML into another ... (3)
-> + Help Needes (3)
-> - Help needed! (1)
-> + Conv of DSML Format to XML for... (2)
-> - Regd, entering text in the t... (1)
-> + displaying all the text around... (4)
-> + inserting values into empty ta... (5)
-> + How to get rid of xmlns="" att... (3)
-> + XSLT How to include the '<' sy... (2)
-> - HELP: Functional XSLT Implemen... (1)
-> - Cannot find a matching 1-argum... (1)
-> + XSLT a:? (2)
-> + Attribute Value Concatenation (2)
-> - Why is the WYSIWYG xslt editor... (1)
-> + WebService Call Error: Ref ele... (4)
-> + How to replace value of a fiel... (2)
-> + Schema Validation Problems (3)
-> + Reusing a prior valid value in... (5)
-> + Clutching at straws! (2)
-> + Adding a number to a for each ... (2)
-> + Transform Name Value pairs int... (4)
-> + Transform the XML Scheme with ... (2)
-> + create XML drop down lists (2)
-> + error during stylesheet tutori... (3)
-> + Modify the value in a element ... (2)
-> + Call to extension function fai... (2)
-> + Convert XML Schema to XML - Mi... (2)
-> + How to calculate maximun RowCo... (3)
-> + Help with using not(preceding:... (5)
-> - Please Help me on this XML to ... (1)
-> + Paasing Parameter Values From ... (6)
-> + XSLT Transformation w/ namespa... (3)
-> + For-each select and parameter ... (3)
-> + Using < (less than) operator (5)
-> + Inserting carriage return (spe... (3)
-> + Inserting carriage return (spe... (2)
-> + Help with SerializerTrace erro... (8)
-> + xml to x3d (5)
-> + Exiting processing loop early (2)
-> + Easy way to Convert One source... (3)
-> + XSLT Editor tab missing from D... (2)
-> + Writing strings of characters ... (4)
-> + Adding the content of an eleme... (3)
-- Previous [601-620] [621-640] [641-660] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
chandra mouliSubject: problem with sorting table contents based on randomly selected header
Author: chandra mouli
Date: 27 Sep 2004 05:22 AM
hi all,

this is chandramouli.
this is my urgent requirement.

i have the problem with sorting the table contents based on
dynamically selected header.

can u plz solve my problem.

i have written my xml code like this

<?xml version="1.0" encoding="UTF-8" ?>
<userdetails>
<user>
<name>mouli</name>
<id>t001</id>
<designation>trainee</designation>
</user>
<user>
<name>naveen</name>
<id>t002</id>
<designation>student</designation>
</user>
<user>
<name>chandra</name>
<id>t004</id>
<designation>software engineer</designation>
</user>
<user>
<name>haritha</name>
<id>t004</id>
<designation>student</designation>
</user>
</userdetails>

the xsl code that i have written to display the above xml content in
table format. In that code itself i have written the code to dynamically
sort the table data. but it is not properly working.
when i use the static variable instead of that dynamic variable. it is
working nice.

xsl code that i have written is .

<?xml version='1.0' encoding='UTF-8'?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:output method="html" />
<xsl:param name="Sor"/>
<xsl:param name="Page"/>

<xsl:template match="/">
<table border="1">
<xsl:call-template name="header"/>
<xsl:apply-templates select="*/*">
<xsl:sort select="*[$Sor]"/>
</xsl:apply-templates>
</table>
</xsl:template>

<!-- creates the table headers from the tag names -->
<xsl:template name="header">
<tr>
<xsl:for-each select="*/*[1]/*">
<th>
<A href="{$Page} ?Sor={position()}">
<xsl:value-of select="local-name(.)" />
</A>
</th>
</xsl:for-each>
</tr>
</xsl:template>

<!-- creates a row for each child of root, -->
<!-- and cell for each grandchild of root -->
<xsl:template name="content" match="*/*">
<tr>
<xsl:for-each select="*">
<td><xsl:value-of select="." /></td>
</xsl:for-each>
</tr>
</xsl:template>

</xsl:stylesheet>

inaddition to this i have written some code in jsp to integrate both xml
and xsl code..

jsp code that i have written is

<html>
<body>
<script type="text/javascript">// Load XML
var xml = new ActiveXObject("Microsoft.XMLDOM")
xml.async = true
xml.load("data.xml")

// Load XSL
var xsl = new ActiveXObject("Microsoft.XMLDOM")
xsl.async = true
xsl.load("xslsort.xsl")

// Transform
document.write(xml.transformNode(xsl))
</script>


</body>
</html>

any one of u plz suggest me the solution.

of my knowledge every thing is fine but the page not getting refreshed.
if it is the case plz any one of you suggest me the solution.

this is my urgent requirement. plz suggest me the solution.

thanks in advance...


thanks and regards,
chandramouli.p

Posttop
Ivan PedruzziSubject: problem with sorting table contents based on randomly selected header
Author: Ivan Pedruzzi
Date: 29 Sep 2004 06:33 PM
Hi Chandra,

Here is one of the possible approaches to implment what you are looking for

1) This a simple XSLT that produce the HTML table

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html"/>
<xsl:param name="sortby" select="'name'"/>

<xsl:template match="/">
<div id="divID">
<table border="1">
<xsl:call-template name="header"/>
<xsl:apply-templates select="userdetails/user">
<xsl:sort select="*[name()=$sortby]" data-type="text"/>
</xsl:apply-templates>
</table>
</div>
</xsl:template>

<xsl:template name="header">
<tr>
<xsl:for-each select="*/*[1]/*">
<th>
<a href="sorttable.asp?sortby={local-name(.)}">
<xsl:value-of select="local-name(.)"/>
</a>
</th>
</xsl:for-each>
</tr>
</xsl:template>

<xsl:template match="user">
<tr>
<td><xsl:value-of select="name"/></td>
<td><xsl:value-of select="id"/></td>
<td><xsl:value-of select="designation"/></td>
</tr>
</xsl:template>
</xsl:stylesheet>


2) This is the Active Server Page that run the stylesheet.
The result is a HTML page with a clickable header to do sorting


<%@ LANGUAGE = jscript %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Sortable Table</title>
</head>
<body>
<%
var sortby = Request.QueryString("sortby");
var xmlpath = Server.mappath("sorttable.xml");
var xslpath = Server.mappath("sorttable.xsl");

var xslt = new ActiveXObject("Msxml2.XSLTemplate.4.0");
var xsldoc = new ActiveXObject("Msxml2.FreeThreadedDOMDocument.4.0");
var xmldoc = new ActiveXObject("Msxml2.DOMDocument.4.0");
var xslproc;

xsldoc.async = false;
xsldoc.load(xslpath);

if (xsldoc.parseError.errorCode != 0) {
var myErr = xsldoc.parseError;
Response.write(myErr.reason);
} else {
xslt.stylesheet = xsldoc;
xmldoc.async = false;
xmldoc.load(xmlpath);
if (xmldoc.parseError.errorCode != 0) {
var myErr = xmldoc.parseError;
Response.write(myErr.reason);
} else {
xslproc = xslt.createProcessor();
xslproc.input = xmldoc;
xslproc.addParameter("sortby", String(sortby));
xslproc.transform();
Response.write(xslproc.output);
}
}
%>
</body>
</html>

For your convenience I also attached the files as zip

Hope this helps
Ivan


Documentsorttable.zip
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.