Re: IF - ELSE expression into an XSP with ESQL

[Christopher Painter-Wakefield]

yes, you can nest <xsp:logic> and <esql:...> tags as much as you want.  The
esql tags just create java code anyway, so you can insert your java code as
needed.

-Christopher




|---------+---------------------------->
|         |           Josep Riudavets  |
|         |           Aguilo           |
|         |           <[EMAIL PROTECTED]|
|         |           edu>             |
|         |                            |
|         |           10/13/2003 09:06 |
|         |           AM               |
|         |           Please respond to|
|         |           users            |
|         |                            |
|---------+---------------------------->
  
>--------------------------------------------------------------------------------------------------------------|
  |                                                                                    
                          |
  |       To:       "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>                            
              |
  |       cc:                                                                          
                          |
  |       Subject:  IF - ELSE expression into an XSP with ESQL                         
                          |
  
>--------------------------------------------------------------------------------------------------------------|




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]



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