[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Summarising XML datasets
Hi, > I have a problem formatting some XML I am receiving from a 3rd party > application that I cannot alter. > > The application is querying a database that has a table > called photo and a > table called photosubject, there is a one to many > relationship between photo > and photosubject. snip > What I want to do if possible is to render the information > using xslt as: > > HouseID | House | Description | Subjects > =========================================== > 1 | House | House 1 | X, Y, Z XSLT 2.0 solution <tbody> <xsl:for-each-group select="results/photograph" group-by="id"> <tr> <td> <xsl:value-of select="id"/> </td> <td> <xsl:value-of select="name"/> </td> <td> <xsl:value-of select="description"/> </td> <td> <xsl:value-of select="current-group()/subject" separator=", "/> </td> </tr> </xsl:for-each-group> </tbody> See <http://www.jenitennison.com/xslt/grouping/> how to achieve this using XSLT 1.0 and the Muenchian Method. Cheers, Jarno
|
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
|