Hi! Since I can't check the code repository for a newer version of the ESQL
taglib which might be fixed by now (or I'm the only thing "broken" here), I
would apreciate some comments on some "findings" I've made :
Look at this fragment from the esql taglib and read the comments I've placed in
it :
<?xml version="1.0"?>
<!-- $Id: esql.xsl,v 1.54 2001/01/22 23:49:44 balld Exp $-->
<!--
(...)
// line number is 406
<!-- this is a normal query -->
<xsl:otherwise>
_esql_query.statement = _esql_connection.connection.createStatement();
_esql_query.results = _esql_query.statement.execute(_esql_query.query);
</xsl:otherwise>
</xsl:choose>
// my debug
System.out.println("ESQL : _esql_query.query = " + _esql_query.query);
System.out.println ("ESQL : _esql_query.results = " + _esql_query.results);
// the query's fine, and "_esql_query.results == false" as it should, since from
// JAVA 1.3 Documentation for java.sql.statement, execute() returns false
// for an update/insert or *no results matching the query* !!!
if (_esql_query.results) {
_esql_query.resultset = _esql_query.statement.getResultSet();
_esql_query.resultset_metadata = _esql_query.resultset.getMetaData();
_esql_query.position = 0;
if (_esql_query.skip_rows > 0) {
while (_esql_query.resultset.next()) {
_esql_query.position++;
if (_esql_query.position == _esql_query.skip_rows) {
break;
}
}
}
<xsl:apply-templates select="esql:results"/>
<xsl:apply-templates select="esql:no-results"/>
_esql_query.resultset.close();
}
else {
_esql_query.position = _esql_query.statement.getUpdateCount();
if (_esql_query.position >= 0) {
<xsl:apply-templates select="esql:update-results/*"/>
}
}
_esql_query.statement.close();
// since _esql_query.results == false, i guess from this that "esql:no-results"
// never gets instantiated.
I can't find any reasonable explanation for why only now I've found this
problem with esql. Donald, please can you give me a help?! Am I missing
something???? I've used the no-results tag more than once ... I didn't found any
"malfunction" earlier just because the no-results condition was never met ...
until now.
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
