XSQL & XSL - translation difficulties (newbie problem)

Subject: XSQL & XSL - translation difficulties (newbie problem)
From: Alex Golden F-65 coop <agolden@xxxxxxxxx>
Date: Wed, 19 Jul 2000 11:37:44 -0400
   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


Current Thread