SSDN - How do I do this ?

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Mike L

Subject: 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>

(Deleted User)

Subject: How do I do this ?
Author: (Deleted User)
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

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.