Help with XSL/XML

learnxsl · April 30th, 2010, 04:20 PM

Hi,

I am a beginner to XSL/XML. I may not be using proper terms in describing my question. Please excuse.

I have a XML file which looks like below -

Code:

	<Emp>
		<SSN>xxx-xx-xxxx</SSN>
		<Name>ABC</Name>
		<Phone>6507231234</Phone>
		<Phone>6507553223</Phone>
	</Emp>
        <Emp>
		<SSN>xxx-xx-xxxy</SSN>
		<Name>BCD</Name>
		<Phone>6507231235</Phone>
		<Phone>6507553226</Phone>
	</Emp>

I have written a XSL file to display the data in XML onto HTML. Part of the code looks like as shown below -

Code:

  <table>
      <tr>
        <th>SSN</th>
        <th>Name</th>
        <th>Phone</th>
      </tr>
      <xsl:for-each select="Emp">
        <tr>
          <td><xsl:value-of select="SSN"/></td>
          <td><xsl:value-of select="Name"/></td>
          <td><xsl:value-of select="Phone"/></td>
        </tr>
      </xsl:for-each>
    </table>

The above code displays just the first value of Phone. How should I modify the code to display the multiple values

samjudson · April 30th, 2010, 04:34 PM

Simply use another for-each loop:

Code:

<xsl:for-each select="Phone">
<xsl:value-of select="."/>
<xsl:if test="position()!=last()">,</xsl:if>
</xsl:for-each>

mhkay · April 30th, 2010, 04:43 PM

In fact, this is an area where XSLT 2.0 differs from 1.0: in XSLT 2.0 (if your stylesheet specifies version="2.0", the code you supplied <xsl:value-of select="Phone"/> will output all the phone numbers, space separated; if you want a different separator, you can use <xsl:value-of select="Phone" separator=","/>. In XSLT 1.0, however, you need another xsl:for-each loop.

learnxsl · April 30th, 2010, 04:53 PM

Interesting to know about this difference between Version 1.0 and 2.0.

Had I created XSLT 2.0, my code would have worked and I would not have known the difference. Nice learning.

Thanks to all.