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>
>

