[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
RE: [xsl] Transforming XML to XML (diff. format) using XSL
|
Subject: RE: [xsl] Transforming XML to XML (diff. format) using XSL From: Jarno.Elovirta@xxxxxxxxx Date: Tue, 3 Jun 2003 14:08:20 +0300 |
Hi,
> I trying to transform a XML file (created from a MySQL DB)
> into another
> XML file listing FIXED bug details in a table and a brief
> description in an
> order list . Problem: how do I use <xsl:for-each select="">
> to refer to
> each of the field names in the source? I would like to say
> display the
> value of "bug_id" inside the <li> tag within a ordered list
> and create a
> hyperlink to the bug page inside the table.
Use AVTs <http://www.w3.org/TR/xslt#attribute-value-templates>. See the stylesheet fragment below, for the AVT usage and how to select the fields you want.
<xsl:template match="/">
<xml>
<document>
<properties>
<author email="vipul.vij@xxxxxxxxxx">Vipul Vij</author>
</properties>
<body>
<section name="Bugs fixed">
<xsl:variable name="fixed" select="mysqldump/database/table/row[field[@name = 'status_id'] = 7 and field[@name = 'resolution_id'] = 1]"/>
<p>Summary of bugs that have been now fixed</p>
<xsl:if test="$fixed">
<ol>
<xsl:for-each select="$fixed">
<xsl:sort select="field[@name = 'bug_id']"/>
<li>
<xsl:value-of select="field[@name = 'title']"/>
</li>
</xsl:for-each>
</ol>
</xsl:if>
<table>
<tr>
<td>Bug ID</td>
<td>Name</td>
<td>Description</td>
<td>Fixed by</td>
</tr>
<xsl:for-each select="$fixed">
<xsl:sort select="field[@name = 'bug_id']"/>
<tr>
<td>
<a href="http://intranet/phpbt-0.9.1/bug.php?op=show&bugid={field[@name = 'bug_id']}">
<xsl:value-of select="field[@name = 'bug_id']"/>
</a>
</td>
<td>
<xsl:value-of select="field[@name = 'title']"/>
</td>
<td>
<xsl:value-of select="field[@name = 'description']"/>
</td>
<td>
<a href="mailto:vipul.vij@xxxxxxxxxx">Vipul Vij</a>
</td>
</tr>
</xsl:for-each>
</table>
</section>
</body>
</document>
</xml>
</xsl:template>
Cheers,
Jarno - Delerium: Heaven's Earth (Matt Darey remix)
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
| Current Thread |
|---|
|
| <- Previous | Index | Next -> |
|---|---|---|
| Re: [xsl] Transforming XML to XML (, David Carlisle | Thread | RE: [xsl] Transforming XML to XML (, vipul . vij |
| [xsl] Transforming XML to XML (diff, vipul . vij | Date | [xsl] parse inside a cdtata, Sebastien GRUHIER |
| Month |
Keywords