This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
XSQL & XSL - translation difficulties (newbie problem)
- To: xsl-list at mulberrytech dot com
- Subject: XSQL & XSL - translation difficulties (newbie problem)
- From: Alex Golden F-65 coop <agolden at mitre dot org>
- Date: Wed, 19 Jul 2000 11:37:44 -0400
- Organization: Mitre
- Reply-To: xsl-list at mulberrytech dot com
Hey all, I started working with XSQL & XSL a few days ago... I have
successfully queried the database with XSQL, but I'm having problems
using XSL to translate the results to HTML... In the HTML created using
the XSL file the table row where the results should be is always
blank.... I must be making a little mistake or typo, if someone could
take a look at my code and give any suggestion I'd really appreciate it:
security_clearance.xsql:
<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="security_clearance.xsl"?>
<query connection = "caat">
SELECT last_name, first_name, security_clearance_id
from alex_security_clearances
</query>
security_clearance.xsl:
<html xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<head>
<title>Query Results:</title>
</head>
<body>
<table border="1" cellspacing="0">
<tr>
<th>Last Name</th>
<th>First Name</th>
<th>Security Clearance ID</th>
</tr>
<xsl:for-each select = "ROWSET/ROW">
<tr>
<td><xsl:value-of select="LAST_NAME"/></td>
<td><xsl:value-of select="FIRST_NAME"/></td>
<td><xsl:value-of select="SECURITY_CLEARANCE_ID"/></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
... The results when not translated look something like:
<?xml version = '1.0'?>
<ROWSET>
<ROW num="1">
<LAST_NAME>Doe</LAST_NAME>
<FIRST_NAME>Jane</FIRST_NAME>
<SECURITY_CLEARANCE_ID>12467</SECURITY_CLEARANCE_ID>
</ROW>
<ROW num="2">
<LAST_NAME>Doe</LAST_NAME>
<FIRST_NAME>John</FIRST_NAME>
<SECURITY_CLEARANCE_ID>68165</SECURITY_CLEARANCE_ID>
</ROW>
</ROWSET>
Thanks in advance!
-Alex
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list