Hi Folks,

I have a problem when I try to rename an element, that all the child nodes of the element are wiped out.

I am trying to convert an ADODB.RecordSet to a more readable form:

<rs:data>
    <z:row CarVidNo="33445566" CarRegNo="345rtgy" CarMake="Renault" CarModel="Clio" CarColour="Blue" CarEngine="1.2" CarPrice="5000"/>
    <z:row CarVidNo="55667788" CarRegNo="SXI 6002" CarMake="Vauxhall" CarModel="Corsa" CarColour="White" CarEngine="1.1" CarPrice="1000"/>
</rs:data>

Like So:

<z:row>
    <CarVidNo>33445566</CarVidNo>
    <CarRegNo>345rtgy</CarRegNo>
    <CarMake>Renault</CarMake>
    <CarModel>Clio</CarModel>
    <CarColour>Blue</CarColour>
    <CarEngine>1.2</CarEngine>
    <CarPrice>5000</CarPrice>
</z:row>

However, when I try to convert <z:row> to another name, say <cars> I get this:

<Cars/>

Here is the stylesheet I am using:


<xsl:import href="copy.xslt"/>

    <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes" />


      <xsl:template match="*[z:row]">


                <xsl:apply-templates/>

      </xsl:template>


        <xsl:template match="s:Schema">
                <xsl:for-each select="z:row">
                    <xsl:apply-templates />
                </xsl:for-each>
        </xsl:template>


        <xsl:template match="z:row/@*">
          <xsl:element name="{name( )}">
                <xsl:value-of select="." />
          </xsl:element>
        </xsl:template>


        <xsl:template match="z:row">
          <xsl:element name="Cars">
                <xsl:apply-templates select="z:row"/>
          </xsl:element>
        </xsl:template>
</xsl:stylesheet>


And here is the copy stylesheet:


<xsl:template match="node( ) | @*">
  <xsl:copy>
    <xsl:apply-templates select="@* | node( )"/>
  </xsl:copy>
</xsl:template>


I am at a loss with this, been looking around the net and in some books, but as far as i can see, this should work.

Thanks for your help!

Morris

<xsl:template match="z:row">
          <xsl:element name="Cars">
                <xsl:apply-templates select="z:row"/>
          </xsl:element>
        </xsl:template>

A z:row element does not have any children called z:row, so this apply-templates will select nothing.

You want <apply-templates select="@*"/>.

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

Hey!!

Oh so simple when you know how!! :o)

Thanks for your help, it is much appreicated!

Morris