Varga, Zsombor wrote:
I have a SQL query in an XSP (using the esql logicsheet) that
returns a record. If the query returns no record, it
currently returns an empty node set. I don't want it to do
that. Instead I want it to fail so execution stops there.
What is the best (most efficient) way of doing this.
You can catch the empty resultset with the <esql:no-results> , here you
can throw an Exception (we are using for this cases the
ProcessingException).
Or you can use variables, and each time you do something, take a look at
that variable.
Thanks for that. What I did was create a boolean variable called
hasFailed, updated this on no-result and then in a xsp:logic call after
esql connection, throw the exception if hasFailed is true.
--
Kamal Bhatt
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
