How to include an external xml file into a xslt to display its contents?

[Rich Griff]

Hi all im quite new to xslts and finding it fairly difficult. The problem ive got is trying to use an xslt to display contents of two xml files. Ive managed to style one xml file but need to include contents from another xml file.

Im using the following code to try and add in the contents of a product.xml file:

<xsl:for-each select="document('products.xml')/models/model"/>

But it doesnt show up anything on the page. Ive got a funny feeling that im missing something, and knowing me i am, i was hoping someone could shed some light on this for me????

The layout of my product.xml file is:

<models>
<model>
<name></name>
<price></price>
<include>
<dept></dept><sub-dept></sub-dept>
</include>
</model>

The <include> tag is for products to be certain sub-departments within departments. If this helps.

Thanks in advance.

Rich