XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » How do I do this ?
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> - How do I do this ? (2)
-> ->How do I do this ?
-> + Accessing an attribute based o... (3)
-> + help needed - using saxon thro... (2)
-> + Grouping Problem still (6)
-> + Use XSL-FO to create tables fr... (6)
-> + taking out a child and (6)
-> + Yet another problem (3)
-> + using XSL-FO to convert PDF (4)
-> + Preventing namespace declarati... (2)
-> + Small problem during conversio... (4)
-> + Problems removing namespaces (2)
-> + Grouping/Following question (4)
-> + Transforming XML into another ... (3)
-> + Help Needes (3)
-> - Help needed! (1)
-> + Conv of DSML Format to XML for... (2)
-> - Regd, entering text in the t... (1)
-> + displaying all the text around... (4)
-> + inserting values into empty ta... (5)
-> + How to get rid of xmlns="" att... (3)
-- Previous [661-680] [681-700] [701-720] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
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
(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
   
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.