IF - ELSE expression into an XSP with ESQL

[Josep Riudavets Aguilo]

Hi all ...

I need some help about IF-ELSE expression into an XSP page, with
some ESQL taglibs.

I have implemented a conection pool to a postresql database. First
of all, I make a query to the database:

<esql:query>SELECT solicitat FROM expedients WHERE
nom='<xsp:expr>nom</xsp:expr>' AND
cognoms='<xsp:expr>cognoms</xsp:expr>' AND
dni='<xsp:expr>dni</xsp:expr>';
</esql:query>

The object of this query is to capture "solicitat" value from the
database, a boolean value.

If "solicitat" is false, I need to access de database in order to
capture more values.

<esql:execute-query>
<esql:query>SELECT mail FROM expedients WHERE
nom='<xsp:expr>nom</xsp:expr>' AND
cognoms='<xsp:expr>cognoms</xsp:expr>' AND
dni='<xsp:expr>dni</xsp:expr>';
</esql:query>
<esql:results>
<esql:row-results>
...
</esql:row-results>
</esql:results>
</esql:execute-query>

If "solicitat" is true, no more database access are allowed, and the
XSP must ignore the second query.

How can I implement this IF-ELSE expression? I know about
<xsp:logic> taglib for implementing java code, but I don't know if
ESQL taglibs can be placed into <xsp:logic> taglib.

Thans a lot.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]