Summary This snippet demonstrates filtering, sorting and highlighting HTML tables that use xml data islands.

Additional information

Well, the full sourcecode is downloadable. However, the cliffnotes are shown below. The source code is documented as well and will explain it all. a) To add the ability to highlight the current row and "sort by clicking on the column header" you will need to simply add the behavior to the table as follows: <table style="Behavior: url(TableSortAndHighlight.htc)"....> b) To indication which xml attribute in the xml document is sorted when you click on the column header, just add the "SortField" attribute to the html table column. Examples are as follows: <td SortField="FirstName"..... <td SortField="LastName"..... <td SortField="ResidenceType"..... <td SortField="ResidenceType".... <td SortField="State">State..... Yes, this assumes that the xml document is attribute normalized, but it is not a very big leap to modify to handle xml documents that are element normalized. c) The Filtering is done via passing parameters to an XSLT file using VBScript. The code is shown below: <Script Language=VBScript> function vbFilterTable(strLocation, strOccupation, strType) dim objXSL, objXML, objTemplate, objProcessor, strHTML Set objXML = CreateObject("Msxml2.FreeThreadedDOMDocument") Set objXSL = CreateObject("Msxml2.FreeThreadedDOMDocument") 'Load the XML document objXML.async = False objXML.Loadxml xmlDSOorig.xml 'Load the XSL document objXSL.async = False objXSL.Loadxml xslFilter.xml 'Create an instance of our XSL Template object Set objTemplate = CreateObject("MSXML2.XSLTemplate") 'Create an instance of our stylesheet object using our recently loaded XSLT document Set objTemplate.stylesheet = objXSL 'Create an instance of our Processor object Set objProcessor = objTemplate.createProcessor 'Define the input object for our object equal to our recently loaded XML document objProcessor.input = objXML 'Now, finally we can add any parameters that we require to our Template processor 'In this example, we are setting the drinktype = "house" objProcessor.AddParameter "location", strLocation objProcessor.AddParameter "occupation", strOccupation objProcessor.AddParameter "type", strType 'Last but not least we do our transformation objProcessor.Transform 'Store the results of the output into a string. strXML = objProcessor.output 'Load up an XML DOM object from the recent XML output objXML.loadxml strXML 'Select only the "employees" elements from our document object objXML.selectNodes("//root") 'Load our Data Island using our new XML object xmlDSO.loadxml objXML.xml end function </script>