cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Urs Iwert" <>
Subject How do I use session parameters in a ESQL-Logicsheet
Date Thu, 14 Jul 2005 15:19:32 GMT

I need data from a database using ESQL-Logicsheet. The sql statement
must be filtered depending on the current session (user logon) and on
session parameters. The session parameters are used, because there are
quite a lot of parameters and all of them are used to query different

What if done yet

- Logon using session framework
- Saving parameters in a session using <setxml/>
- ESQL LogicSheet to access data (all records by now)

What's missing is the last step to bring the filter criterias to the
where clause of my sql statement. This has to be done before execution
of the sql statement. Here is a simplified example 

        <!-- how do I bring the filter criterias to sql statement below
          select group_id, lastname, firstname, birthdate,  from
          where group_id = [session variable group_id]
            and birthdate <= [session variable date]
          order by lastname, firstname
              <lastname><esql:get-string column="lastname"/></lastname>

Thanks in advance

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message