There is support for this. It's an odd syntax though. Try:
> <select id="getAmount" parameterClass="java.util.List" > > select > ID, AMOUNT > from > TABLE > where ID IN (#[]#) > </select> On Mon, 27 Dec 2004 09:16:03 -0800 (PST), Walter So (JIRA) <[email protected]> wrote: > Support for arrays or list parameter using "IN" keyword > ------------------------------------------------------- > > Key: IBATIS-38 > URL: http://nagoya.apache.org/jira/browse/IBATIS-38 > Project: iBatis for Java > Type: New Feature > Components: SQL Maps > Environment: Any > Reporter: Walter So > Priority: Minor > > I have a need for the following kind of query: > > <select id="getAmount" parameterClass="java.util.List" > > select > ID, AMOUNT > from > TABLE > where ID IN (#ids#) > </select> > > To generate: > select ID, AMOUNT from TABLE where ID IN (1001, 1002, 1003, 1004) > > #ids# can also be int[], String[] or Object[] array. Will there be any > support for these kinds of parameters? Thanks. > > -- > This message is automatically generated by JIRA. > - > If you think it was sent incorrectly contact one of the administrators: > http://nagoya.apache.org/jira/secure/Administrators.jspa > - > If you want more information on JIRA, or have a bug to report see: > http://www.atlassian.com/software/jira > >
