Problems with Document()

malevans · April 29th, 2007, 02:23 PM

Hi all!

I have two xml files for a catalog (Structure.xml) and (Products.xml)an example of each shown below:

Structure.xml

<Structure>
<Section>
        <Title>CD</Title>
    <subsection>
             <Title>CDALBUM</Title>
        </subsection>
        <subsection>
             <Title>CDSingle</Title>
        </subsection>
        <subsection>
             <Title>Compilation</Title>
    </subsection>
    <subsection>
             <Title>Compilation</Title>
        </subsection>
</Section>
</Structure

Products.xml

<Products>
    <Product>
         <displayedin sect="CD" subsect="CDALBUM"/>
         <desc>Crusade - Trivium</desc>
     <desctwo>Genre - Metal</desctwo>
     <Price>8.99</Price>
    </Product>
<Products>

Structure.xml provides a category/subcategory structure and Products.xml will contain product details. In all there will be 4 categories each containing 4 subcategories and i need 1 xslt file to output a html file for each subcategory....

I think i can achieve this by firstly storing Structure/Section/Title as a variable.

Then the next part i need help with...
Maybe something like...

<xsl:variable name="currentsection"select="Structure/Section/Title"/>

<xsl:for-each select="document ('Products.xml')/Products/Product/displayedin[@sect=$currentsection">

(that doesn't work!)

Then something to output a html file for each subsection...

anyone have any ideas?

cheers, mal

bonekrusher · April 29th, 2007, 03:28 PM

Hi, Welcome to the forum

The following line:

<xsl:for-each select="document ('Products.xml')/Products/Product/displayedin[@sect=$currentsection">

attribute @sect is not part of your xml.

mhkay · April 29th, 2007, 04:30 PM

To output multiple result documents from a single transformation you need XSLT 2.0 (the xsl:result-document instruction) unless you are prepared to use vendor-specific extensions.

To do joins in XSLT it's generally easiest and most efficient to use keys:

<xsl:key name="k" match="Product"
  use="concat(displayedin/@sect, '/', displayedin/@subsect)"/>

<xsl:for-each select="Structure/Section/subsection">
  <xsl:result-document href="...">
       <xsl:apply-templates select="key('k',
            concat(../Title, '/', ./Title), document('Products.xml')"/>
  </xsl:result-document>
</xsl:for-each>

Then just write a template rule that matches Product.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference