Cart
|
[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] XSL Challenge
Hi Folks,
Are you up for a mind-bending XSL problem? Someone presented
me with this problem several weeks ago and I have yet to find
a solution. It looks simple. It is deceptively challenging.
An XML document stores database data as follows:
<?xml version="1.0"?>
<DynamicTable>
<Columns>
<Column name="col1"/>
<Column name="col2"/>
</Columns>
<Rows>
<Row>
<Column name="col1">A</Column>
<Column name="col3">B</Column>
<Column name="col2">C</Column>
</Row>
<Row>
<Column name="col2">S</Column>
<Column name="col1">E</Column>
</Row>
<Row>
<Column name="col5">R</Column>
<Column name="col2">G</Column>
<Column name="col1">Q</Column>
</Row>
</Rows>
</DynamicTable>
Note that the columns that we are interested in are col1 and col2.
A <Row> element may contain data from columns not of interest.
But, it will always contain at least data for col1 and col2.
The problem is to create an XSL stylesheet that generates an
HTML table with a table header:
col1 col2
and within the table it has the row data. So the HTML table
should look like this:
col1 col2
A C
E S
Q G
I have shown an XML document which has just two columns. However,
the XSL stylesheet needs to be generic and capable of handling
XML documents with any number of columns (as listed in the <Columns>
section).
/Roger
P.S. Below is what I tried, which doesn't work.
<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/TR/WD-xsl"
result-ns="html">
<xsl:template match="DynamicTable">
<HTML>
<HEAD>
<TITLE>Dynamic Table</TITLE>
</HEAD>
<BODY>
<TABLE BORDER="1" WIDTH="50%">
<TR>
<xsl:for-each select="Columns/Column">
<TH><xsl:value-of select="@name"/></TH>
</xsl:for-each>
</TR>
<xsl:for-each select="Rows/Row">
<TR>
<xsl:for-each select="../../Columns/Column">
<TD><xsl:value-of
select="../../Rows/Row/Column[@name='{@name}']"/></TD>
</xsl:for-each>
</TR>
</xsl:for-each>
</TABLE>
</BODY>
</HTML>
</xsl:template>
</xsl:stylesheet>
xml-dev: A list for W3C XML Developers. To post, mailto:xml-dev@i...
Archived as: http://www.lists.ic.ac.uk/hypermail/xml-dev/ and on CD-ROM/ISBN 981-02-3594-1
To (un)subscribe, mailto:majordomo@i... the following message;
(un)subscribe xml-dev
To subscribe to the digests, mailto:majordomo@i... the following message;
subscribe xml-dev-digest
List coordinator, Henry Rzepa (mailto:rzepa@i...)
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! 
Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|
|||||||||
