After I wrote I too tested the XSL file on a "hardcoded" XML file and it
worked for me too... Now I think it's a problem with the XSQL file... I'm
fairly sure that when I include the stylesheet like so:

<?xml version = '1.0'?>
<?xml-stylesheet type="text/xsl" href="security_clearance.xsl"?>
<xsql:security_clearances xmlns:xsql="urn:oracle-xsql" connection="caat">
   <xsql:query>
      select *
      from security_clearances
   </xsql:query>
</xsql:security_clearances>

it doesn't process the <xsql:query> as a query... But the following file
successfully queries the database and returns results:

<?xml version = '1.0'?>cat test
<xsql:security_clearances xmlns:xsql="urn:oracle-xsql" connection="caat">
<xsql:query>
   select *
   from security_clearances
</xsql:query>
</xsql:security_clearances>

   So for some reason, in the first XSQL file, it doesn't actually query the
database... But I know that querying works because if I load the second XSQL
file then it queries the database as it should... I'm stumped, thanks for any
advice!

-Alex



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list