Re: Problem with xsp/esql

[Olivier Billard]

In this particular case, I (humbly and personnaly) only see the solution of using 2 separate execute-query, maybe with collecting 
the results and render them separately outside the queries, in this case, the render code is not duplicated. But if the results 
are numerous, it is not performant.

--
Olivier
PS : I personnaly don't user <esql:parameter> and escape them via a function... it 
avoids these brain-twisters...
Thomas Zehetbauer wrote:
In my opinion this does not look "simple" or "nice" and only allows me
to execute 2 of the desired 3 queries, how should I reformat this one:
SELECT English,German FROM GermanEnglish WHERE English REGEXP
<esql:parameter><xsp:expr>query</xsp:expr></esql:parameter> OR German
REGEXP <esql:parameter><xsp:expr>query</xsp:expr></esql:parameter> ORDER
BY English
Of course I could simply put the <xsp:logic> outside the <esql:execute-
query> and copy the <esql:results> block, but I think we agree that copy
and paste is evil practice and should be avoided. I can think of many
situations where similar behaviour is desired and wonder if esql cannot
be used for these.
Tom

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