XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
andre saputraSubject: Need Help with xsl
Author: andre saputra
Date: 01 May 2005 07:52 AM
Hi, im a beginner in xml and xslt and facing a problem in learning the technology.. perhaps one of the guru here can help ? ^^

my problem resolve around merging multiple xml document in order to achieve a relational database capabilities. So for example, from these data below i want to get all the the data structured with which courseID with its matching offerings (all of them) and until now i can only get the first offering (i cant get all of them)... anyone can help with the xsl ?


main.xml

<courses>
<course>
<courseName>Introduction to Database System</courseName>
<courseID>004083</courseID>
<credit>12</credit>
</course>
<courses>

permanentData.xml

<courses>
<course>
<courseID>004083</courseID>
<offerings>
<offering>test</offering>
<offering>test2</offering>
</offerings>
</course>
</courses>

Posttop
Minollo I.Subject: Need Help with xsl
Author: Minollo I.
Date: 01 May 2005 09:34 PM
Something like this?

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html"/>
<xsl:template match="/">
<table border="1">
<xsl:for-each select="courses/course">
<tr>
<td><xsl:value-of select="courseName"/></td>
<td><xsl:value-of select="courseID"/></td>
<td>
<table>
<xsl:for-each select="document('permanentData.xml')/courses/course[courseID=current()/courseID]/offerings/offering">
<tr>
<td><xsl:value-of select="."/></td>
</tr>
</xsl:for-each>
</table>
</td>
</tr>
</xsl:for-each>
</table>
</xsl:template>
</xsl:stylesheet>

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
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.