Re: using #value[]#

[Paulo Ferreira de Moura Junior]

On 6/9/05, Paul Barry <[EMAIL PROTECTED]> wrote:
> The query I would like to end up with is:
>
> SELECT
>   session_id, count(*) count
> FROM
>   events
> WHERE
>   session_id IN (1,2,3)
> GROUP BY
>   session_id

   Try this :

<select id="findCountsBySession" parameterClass="list" resultMap="counts">
SELECT
  session_id as id, count(*) count
FROM
  events
<dynamic prepend="WHERE">
  <iterate property="value" open="session_id IN (" close=")"
           conjunction=",">
        #value[]#
  </iterate>
</dynamic>
GROUP BY
  session_id
</select>

   Regards.