Hello again Torsten,
if my query didn't return any row, a call to the execute() method
returns false, right?
Therefore, for a no-results situation, the code resulting from the
application
of the esql:no-results template is never reached - this is what I
understand from reading
the java code below. Am I right?! I guess it's highly probable that I'm
grossly wrong,
but this is the only place in the esql.xsl file where the template is
apllied.
I don't wan't to execute java code when I do an update or insert, but
when my
"SELECT title FROM test WHERE title = 'a title' " query returns no rows
- for this 3
situations, the execute() method's will return false and not a ResultSet
Object.
What am I missing?!?!?
Conclusion : I need mutual exclusivity between 'no-results' and
'update-results' (mutual
exclusivity between 'no-results' and 'results' is assured by the
true/false return values of the
execute() method).
Thanks for your attention. I really must solve this (i could just edit
esql.xsl to "correct"
this, but I wan't to really make sure this is what I have to do).
esql taglib v1.86
=================
<<line 503>>
if (_esql_query.results) {
do {
_esql_query.resultset = _esql_query.statement.getResultSet();
_esql_query.resultset_metadata =
_esql_query.resultset.getMetaData();
_esql_query.position = 0;
if (_esql_connection.use_limit_clause == 0 &&
_esql_query.skip_rows > 0) {
while (_esql_query.resultset.next()) {
_esql_query.position++;
if (_esql_query.position == _esql_query.skip_rows) {
break;
}
}
}
if (_esql_query.resultset.next()) {
<xsl:apply-templates select="esql:results"/>
}
else {
<xsl:apply-templates select="esql:no-results"/>
}
_esql_query.resultset.close();
} while(_esql_query.statement.getMoreResults());
} else {
_esql_query.position = _esql_query.statement.getUpdateCount();
if (_esql_query.position >= 0) {
<xsl:apply-templates select="esql:update-results/*"/>
}
}
---------------------------------------------------------------------
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]>