Colm O'Riordan wrote:
>
> Is this possible ? I have tried the code below but it seems to concat the
> two options rather than choose one.
> Do I need to have the logic outside the execute query tag ? I was hoping to
> avoid this as the results format is the same and I dont want to have to put
> it in twice in the same file.
>
> Suggestions appreciated,
>
> Thanks,
> Colm.
>
> <xsp:logic>
> if(getJock == null)
> {
> </xsp:logic>
> <esql:query>
> select
> DJName, Intro, News, SlotDay, SlotTime, ImagePath
> from
> DJINFO where ID =<xsp:expr>getstatus</xsp:expr>
> </esql:query>
> <xsp:logic>
> }
> else
> {
> </xsp:logic>
> <esql:query>
> select
> DJName, Intro, News, SlotDay, SlotTime, ImagePath
> from
> DJINFO where DJName like<xsp:expr>getJock</xsp:expr>
> </esql:query>
> <xsp:logic>
> }
> </xsp:logic>
In this case, I would rather see something like this:
<esql:query>
select
DJName, Intro, News, SlotDay, SlotTime, ImagePath
from
DJINFO where DJName like <xsp:expr>(getJock == null) ? getstatus :
getJock</xsp:expr>
</esql:query>
See how much less typing there is, and you get predictable results.
Otherwise, you would have to place the whole <esql:execute-query/>
block within the if/else statements.
---------------------------------------------------------------------
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]>