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