Hi,

Can someone please give me a hand with setting CustomerId as an Id Key. It would help me if I can select all data in xmldatasource with this Id Key equal to some index. Below is my current xsl file
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
>
<xsl:output method="xml" indent="yes"/>

<xsl:template match="Employees">
<Employees>
<xsl:apply-templates select="Employee"/>
</Employees>
</xsl:template>
<xsl:template match="Employee">
<Employee>
<xsl:attribute name="CustomerId">
<xsl:value-of select="CustomerId"/>
</xsl:attribute>
<xsl:attribute name="FirstName">
<xsl:value-of select="FirstName"/>
</xsl:attribute>
<xsl:attribute name="LastName">
<xsl:value-of select="LastName"/>
</xsl:attribute>
</Employee>
</xsl:template>
</xsl:stylesheet>


Thanks,

Declare

<xsl:key name="customerId-key" match="Employee" use="CustomerId"/>

as a child of xsl:stylesheet. Then you can locate Employee "12345" using

key('customerId-key', '12345')

It seems a bit odd for employees to have a customer number, but the world moves in strange ways....

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

Thanks for the prompt reply.

Michael,

That was my test xsl file. The real one looks like below after you gave me info in another thread. What do I need to change in order for me to retrieve data with key set to a value?

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl"
>
<xsl:output method="xml" indent="yes"/>
hotelId
<xsl:key name="hotelId-key" match="Hotel" use="hotelId"/>
<xsl:template match="HotelAvailabilityListResults">
<HotelAvailabilityListResults>
<xsl:apply-templates select="Hotel"/>
</HotelAvailabilityListResults>
</xsl:template>

<xsl:template match="Hotel">
<xsl:copy>
<xsl:copy-of select="name | address1 | city | stateProvince | country | postalCode | shortDescription | HotelProperty/RateInfo"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>

Thanks,

You can retrieve a hotel using

key('hotelId-key', 'id123456789')

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