XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Mike  LSubject: How do I do this ?
Author: Mike L
Date: 12 Apr 2008 02:46 PM
I have an XML file that has 7 entries in it. I built my XSL sheet in the layout that I wanted and created my html page but it only shows the first line of data on the web page.

is the issue in the html page or the xsl ?


<html>
<BODY BGCOLOR="#000055">
<table>
<tr>
<td>
<script type="text/javascript">
// Load XML
var xml = new ActiveXObject("Microsoft.XMLDOM")
xml.async = false
xml.load("thelast7days.xml")
// Load XSL
var xsl = new ActiveXObject("Microsoft.XMLDOM")
xsl.async = false
xsl.load("thelast7days.xsl")
// Transform
document.write(xml.transformNode(xsl))</script>
</td></table>
</html>

=========================================


<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="html"/><xsl:template match="/">
<xsl:for-each select="thelast7days/record" />
<html>
<body bgcolor="#999999">
<table border="3">
<tr bgcolor="#9acd32">
<th bgcolor="#ffff55" aligh="center" colspan="11">Midnight readings past 7 days</th></tr>
<tr>
<td bgcolor="#00ff00" font-size="-2">Date</td>
<td bgcolor="#00ff00" font-size="-2">Time</td>
<td bgcolor="#00ff00" font-size="-2">REC Power</td>
<td bgcolor="#00ff00" font-size="-2">REC Daily</td>
<td bgcolor="#00ff00" font-size="-2">REC Monthly</td>
<td bgcolor="#00ff00" font-size="-2">Solar</td>
<td bgcolor="#00ff00" font-size="-2">Solar Daily</td>
<td bgcolor="#00ff00" font-size="-2">Solar Monthly</td>
<td bgcolor="#00ff00" font-size="-2">Net Difference</td>
<td bgcolor="#00ff00" font-size="-2">Net Diff Daily</td>
<td bgcolor="#00ff00" font-size="-2">Net Diff Monthly</td>
</tr>
<tr>
<td bgcolor="#00ff00" font-size="-2"><xsl:value-of select="thelast7days/record/date" /></td>
<td bgcolor="#ffff00" font-size="-4"><xsl:value-of select="thelast7days/record/time" /></td>
<td bgcolor="#ffff00" font-size="-4"><xsl:value-of select="thelast7days/record/NetIn" /></td>
<td bgcolor="#ffff00" font-size="-4"><xsl:value-of select="thelast7days/record/NetIn_D" /></td>
<td bgcolor="#ffff00" font-size="-4"><xsl:value-of select="thelast7days/record/NetIn_M" /></td>
<td bgcolor="#ffff00" font-size="-4"><xsl:value-of select="thelast7days/record/NetOut" /></td>
<td bgcolor="#ffff00" font-size="-4"><xsl:value-of select="thelast7days/record/NetO_D" /></td>
<td bgcolor="#ffff00" font-size="-4"><xsl:value-of select="thelast7days/record/NetO_M" /></td>
<td bgcolor="#ffff00" font-size="-4"><xsl:value-of select="thelast7days/record/Net" /></td>
<td bgcolor="#ffff00" font-size="-4"><xsl:value-of select="thelast7days/record/Net_D" /></td>
<td bgcolor="#ffff00" font-size="-4"><xsl:value-of select="thelast7days/record/Net_M" /></td>
</tr>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>

================================

<thelast7days>
<record>
<date>04/12/2008</date>
<time>11:53:23</time>
<NetIn>63.0</NetIn>
<NetIn_D>7.2</NetIn_D>
<NetIn_M>213.0</NetIn_M>
<NetOut>771.0</NetOut>
<NetO_D>4.0</NetO_D>
<NetO_M>118.3</NetO_M>
<Net>-708.0</Net>
<Net_D>3.2</Net_D>
<Net_M>94.7</Net_M>
<Temp>73.7</Temp>
<Speed>3.6</Speed>
</record>
<record>
<date>04/12/2008</date>
<time>11:53:23</time>
<NetIn>63.0</NetIn>
<NetIn_D>7.2</NetIn_D>
<NetIn_M>213.0</NetIn_M>
<NetOut>771.0</NetOut>
<NetO_D>4.0</NetO_D>
<NetO_M>118.3</NetO_M>
<Net>-708.0</Net>
<Net_D>3.2</Net_D>
<Net_M>94.7</Net_M>
<Temp>73.7</Temp>
<Speed>3.6</Speed>
</record>
<record>
<date>04/12/2008</date>
<time>11:53:27</time>
<NetIn>63.0</NetIn>
<NetIn_D>7.2</NetIn_D>
<NetIn_M>213.0</NetIn_M>
<NetOut>771.0</NetOut>
<NetO_D>4.0</NetO_D>
<NetO_M>118.3</NetO_M>
<Net>-708.0</Net>
<Net_D>3.2</Net_D>
<Net_M>94.7</Net_M>
<Temp>73.7</Temp>
<Speed>3.6</Speed>
</record>
<record>
<date>04/12/2008</date>
<time>11:53:27</time>
<NetIn>63.0</NetIn>
<NetIn_D>7.2</NetIn_D>
<NetIn_M>213.0</NetIn_M>
<NetOut>771.0</NetOut>
<NetO_D>4.0</NetO_D>
<NetO_M>118.3</NetO_M>
<Net>-708.0</Net>
<Net_D>3.2</Net_D>
<Net_M>94.7</Net_M>
<Temp>73.7</Temp>
<Speed>3.6</Speed>
</record>
<record>
<date>04/12/2008</date>
<time>11:53:27</time>
<NetIn>63.0</NetIn>
<NetIn_D>7.2</NetIn_D>
<NetIn_M>213.0</NetIn_M>
<NetOut>771.0</NetOut>
<NetO_D>4.0</NetO_D>
<NetO_M>118.3</NetO_M>
<Net>-708.0</Net>
<Net_D>3.2</Net_D>
<Net_M>94.7</Net_M>
<Temp>73.7</Temp>
<Speed>3.6</Speed>
</record>
<record>
<date>04/12/2008</date>
<time>11:53:27</time>
<NetIn>63.0</NetIn>
<NetIn_D>7.2</NetIn_D>
<NetIn_M>213.0</NetIn_M>
<NetOut>771.0</NetOut>
<NetO_D>4.0</NetO_D>
<NetO_M>118.3</NetO_M>
<Net>-708.0</Net>
<Net_D>3.2</Net_D>
<Net_M>94.7</Net_M>
<Temp>73.7</Temp>
<Speed>3.6</Speed>
</record>
<record>
<date>04/12/2008</date>
<time>11:53:32</time>
<NetIn>63.0</NetIn>
<NetIn_D>7.2</NetIn_D>
<NetIn_M>213.0</NetIn_M>
<NetOut>771.0</NetOut>
<NetO_D>4.0</NetO_D>
<NetO_M>118.3</NetO_M>
<Net>-708.0</Net>
<Net_D>3.2</Net_D>
<Net_M>94.7</Net_M>
<Temp>73.7</Temp>
<Speed>3.6</Speed>
</record>
</thelast7days>


Posttop
Alberto MassariSubject: How do I do this ?
Author: Alberto Massari
Date: 15 Apr 2008 05:05 AM
Hi Mike,
you only see the first row because you write

<xsl:value-of select="thelast7days/record/date" />

You should instead use

<xsl:value-of select="date" />

as the for-each is already placing you at the correct <record>

Alberto

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.