Cart
|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] XSQL & XSL - translation difficulties (newbie problem)
 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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! 
Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|
