Inserting data from secondary XML document ...

All right, I would be extremely grateful if someone could help me with this
problem.

I'm exporting data to two separate files . 

What I am trying to do is, when transforming one xml file, I need to check
the row id of that value in the separate XML file, and replace the string
value with the row id from the second XML file.
The second file has a format like this (Oracle XSU):

<rowset>
	<row num='1'>
		<db_column_name1> value </db_column_name1>
	</row>
	<row num='2'>
		<db_column_name1> value </db_column_name1>
	</row>
<rowset>

I've tried (unsuccessfully) to use the something like the following to
retrieve the row num attribute value from the remote file into a local
variable, with no luck.

<xsl:template match="string1">
<xsl:variable name="temp">
	<xsl:value-of
select="document('second.xml')/*/row/@num[child::*=.]"/>
</xsl:variable>
</xsl:template>

Can someone put me on track?

Thanks,
- Cameron


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list