Thanks for the previous answer, it was an issue with a <xsl:template> tag
actually..resolved it :)
I am getting a "Invalid Driver Name Specified!" when I try to do a
sql:query( ). Any ideas what could be causing it?
Here is an excerpt from my XSLT:
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:sql="org.apache.xalan.lib.sql.XConnection"
extension-element-prefixes="sql"
xmlns:java="java">
<xsl:output method="html" indent="yes"/>
<xsl:param name="driver"
select="'oracle.jdbc.driver.OracleDriver'"/>
<xsl:param name="dbUrl"
select="'jdbc:oracle:thin:@devlp-srv:1521:dvlpnt01'"/>
<xsl:param name="user" select="'TEST'"/>
<xsl:param name="password" select="'TEST'"/>
<xsl:param name="query" select="'select * from QT_VIOL where
QUOTE_NO = 194038 and VIOLATION_NO = 1'"/>
<xsl:template match="/">
<!-- Make the connection -->
<xsl:variable name="dbObj" select="sql:new($dbUrl, $driver,
$user, $password)"/>
<HTML>
<HEAD></HEAD>
<BODY>
<TABLE border="1">
<!-- Execute the query -->
<xsl:variable name="table"
select='sql:query($dbObj, $query)'/>
Thanks,
Kevin
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list