I am struggling to figure out XML and XSL as I go, so please treat me like a complete novice.

I have the following XML output from an SQL database:

- <Target>
- <Target_T Test_Run_ID="47" Target_ID="76" Target_Name_VC="auto-target12">
  <Test_T PF="1" Duration="324" />
  <Test_T PF="1" Duration="371" />
  <Test_T PF="1" Duration="166" />
  <Test_T PF="1" Duration="169" />
  <Test_T PF="2" Duration="0" />
  <Test_T PF="1" Duration="1658" />
  </Target_T>
  </Target>

I'm trying to get a sum of the Duration values, and displaying it in a table. I've created the template at the end of this message, and am calling it via the following:

<xsl:for-each select="Target/Target_T">
<TR>
<TD>
    <xsl:apply-template name="totDuration"/>
</TD>
</TR>
</xsl:for-each>

IE6 reports "Keyword xsl:apply-template may not be used here." I can't figure out why. Can anyone help me? Any hints would be most appreciated.

Here's the template:

<xsl:template name="totDuration">
  <xsl:param name="Tests" select="Test_T" />
  <xsl:param name="subtotal" select="0" />
  <xsl:choose>
    <xsl:when test="$Tests">
      <xsl:call-template name="totDuration">
        <xsl:with-param name="Tests"
                        select="$Tests[position() > 1]" />
        <xsl:with-param name="subtotal"
          select="$subtotal + substring-before($Tests[1], ':')" />
      </xsl:call-template>
    </xsl:when>
    <xsl:otherwise>
      <xsl:value-of select="$subtotal" />
    </xsl:otherwise>
  </xsl:choose>
</xsl:template>

Hi,
IE6 complains because there is no element "xsl:apply-template" in XSLT's namespace (you should write "xsl:apply-templates"). Besides that this element has no "name" attribute; I guess you intended to write "xsl:call-template" instead.
In any case, there is no need to write separate template to sum the values: you can use built-in "sum" function. Drop the template named "totDuration", and change one line in the code you supplied here:
Regards,
Armen

Armen,

Thanks for your reply. You suggested dropping the template and using a one-line xsl:value-of with the SUM function. This is what I started with, but it doesn't work. IE reports

"NodeTest expected here.-->sum(--Test_T/@Duration)"

I'll try correcting my syntax error with the template and see how it goes.

Thanks again,
Ken

Okay, here's the solution I came up with.

The list of durations is the result of an SQL 2000 query, output for XML. It turned out to be easier to edit my stored procedure to do the summation, rather than doing it in my .XSL.

Thanks for your help. Your comments did trigger some thoughts that eventually led me down the right path.

Ken

I'm very glad to help you and it's fine of course that you've found the solution. But it's strange that your IE6 reports the error... My IE6 works fine with the "sum" function. Here is the full code:

target.xsl is:

and target.xml is:

XML doc and XSL stylesheet are in the same directory.

If you'll receive the same error message, it will mean that something with MSXML is wrong(MSXML4 fully conforms to XSLT1.0 specification unlike MSXML3; may be MSXML3 is working in your IE6 and causes the error?).

Regards,
Armen