TopXML SQL XML library : Sort a table using the header of the table

Home Page

Add/Edit your code items

Search the code library

Browse for the code library

SQL XML
SQL XML
SQL XML Contents
Applying a XSLT stylesheet using the DBMS_XMLQuery package
N:N relationships with DBMS_XMLQuery Package
DBMS_XMLQuery package bind values to produce more than one xml file
Download data from a database in XML
Inserting XML file into a table using DBMS_XMLSave Package
Insert XML file into a table using ADO
How to call out to a COM component's method through XSLT
How to select DISTINCT items from XML via XSLT
How to convert Word (RTF) documents to XML for auto publication
Creating SQL Statements with XSLT
SQL straight to XML w/ transform
History Of XML
History Of XML And What Is XML.
Order Automation
You enjoy while you are away and let your machine do the job for you.
SQL Server 2000 User Defined Functions - A Powerful concept
XML/XSLT Maker
Generic ADO recordset to HTML table using XML / XSL
How to display the first three nodes of a XML file with XmlDocument?
What is the usage of the XmlDataDocument?

<< SEO System.XML >>

By	Pedro Gil
First Posted	12/10/2001
Times viewed	284

Sort a table using the header of the table

This post contains attachments
v20011210202651.zip

Summary Using two great snippets together, to bring table sort capability.

Well, I can't say this to be my snippet, but Trace Wilson and Jeremy Byron Snippet...

I used both snippets available at TopXML and was experimenting both, and I did like the outcome, so I've decide to put it up.

Additional information
***** HTML ***** <HTML> <BODY> <HEAD> <TITLE> Test of Sort Table by column head (ADO Persited)</TITLE> <SCRIPT LANGUAGE="JavaScript" FOR="window" EVENT="onload"> showSorted('OrderID','number') </SCRIPT> <SCRIPT LANGUAGE="JavaScript"> function showSorted(SortOrder,SortType) { /* Converted to JavaScript from a code of Trace Wilson at http://www.vbxml.com/snippetcentral How to pass values into an XSLT stylesheet from ASP */ var xml = new ActiveXObject("Msxml2.FreeThreadedDOMDocument"); var xsl = new ActiveXObject("Msxml2.FreeThreadedDOMDocument"); xml.async = false; xsl.async = false; xml.load ("sortTable.xml"); xsl.load ("sortTable.xsl"); var template = new ActiveXObject("Msxml2.XSLTemplate"); template.stylesheet = xsl; var myProc = template.createProcessor(); myProc.input = xml; //XML_RptFormat.documentElement; myProc.addParameter ("SortBy",SortOrder); myProc.addParameter ("SortType",SortType); myProc.transform; RptData.innerHTML = myProc.output; } </SCRIPT> </HEAD> <BODY BGCOLOR="#FFFFFF"> <DIV ID="RptData"> </DIV> </BODY> </HTML> ***** XSLT ***** <?xml version="1.0"?> <xsl:stylesheet version="1.0" exclude-result-prefixes="rs z" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema"> <xsl:output method="html"/>  <xsl:param name = "SortBy"/> <xsl:param name = "SortType" select='number'/> <xsl:template match="/"> <HTML><BODY><TABLE border='1'> <TR bgcolor='#FFFF00'> <TD width='75'><A HREF="javascript:showSorted('OrderID','number')">Order ID</A></TD> <TD width='100'><A HREF="javascript:showSorted('CustomerID','text')">Customer</A></TD> <TD width='75'><A HREF="javascript:showSorted('EmployeeID','number')">Employee</A></TD> <TD width='100'><A HREF="javascript:showSorted('OrderDate','text')">Order Date</A></TD> <TD width='75'><A HREF="javascript:showSorted('Freight','number')">Freight</A></TD> </TR> <xsl:apply-templates select="xml/rs:data/z:row"> <xsl:sort select ='@*[name(.) = $SortBy~' data-type="{$SortType}"/> </xsl:apply-templates> </TABLE></BODY></HTML> </xsl:template> <xsl:template match = "z:row"> <TR> <TD><xsl:value-of select='@OrderID'/></TD> <TD><xsl:value-of select='@CustomerID'/></TD> <TD><xsl:value-of select='@EmployeeID'/></TD> <TD><xsl:value-of select='@OrderDate'/></TD> <TD><xsl:value-of select='@Freight'/></TD> </TR> </xsl:template> </xsl:stylesheet>

Rate this article on a scale of 1 to 10 (0 votes, average 0)

Your vote :

<< SEO System.XML >>


Leave a comment for this article
Your name
Your email (optional)
Your comment
Optional: Upload an attachment
Enter the code shown:



	Recent Jobs Software Developers Needed in Charlotte, Sr. Software Engineer - Analytics Immediate Mainframe openings for Chennai Immediate TANDEM-TAL openings for Chenna Immediate ASP.NET/C# Openings for Chandi View all Jobs (Add yours) View all CV (Add yours)

	it outsourcing swimming pool builder conference call for CA water softener Teleconference Host Department NOLIMIT Web Hosting MSN sunglasses

	Partners Dream.In.Code dotNet Slackers dotNet Spider Your HTML Source VisualBuilder.com DevGuru Planet Source Code ZVON.ORG Web Design ASPAlliance XML Pitstop Scripts The Spot 4 SAP Bitshop Web Hosting

Email TopXML