This works, thanks.

On 6/9/05, Brandon Goodin <[EMAIL PROTECTED]> wrote:
>   <select id="findCountsBySession" parameterClass="list" resultMap="counts">
>   SELECT
>     session_id as id, count(*) count
>   FROM
>     events
>   <dynamic prepend="WHERE">
>       <iterate prepend="session_id IN" open="("
> close=")" conjunction=",">
>         #[]#
>       </iterate>
>   </dynamic>
>   GROUP BY
>     session_id
>  </select>
>

Reply via email to