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