[ http://nagoya.apache.org/jira/browse/IBATIS-38?page=comments#action_57078 ] Roberto Rabe commented on IBATIS-38: ------------------------------------
There is a dynamic <iterate> tag that can be used with a java.util.List property. See page 36 of the SQL Maps 2 Guide PDF found on http://www.ibatis.com/ or pages 34 to 35 of the Data Mapper Guide PDF found on http://incubator.apache.org/ibatis/ . > 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
