[ http://issues.apache.org/jira/browse/IBATIS-38?page=comments#action_59472 ] onsh 76 commented on IBATIS-38: -------------------------------
Hi Clinton, Here is my 2 cents on this issue. I agree with Walter, the code below does not work. I personally need a solution for IN clause badly. > <select id="getAmount" parameterClass="java.util.List" > > select > ID, AMOUNT > from > TABLE > where ID IN (#[]#) > </select> Another thing: I do not want to create a new class that will serve as a container for List-like attribute. Why don't a HashMap serve as container for all my parameters, including List-like attribute? See example below... > <select id="getAmount" parameterClass="java.util.HashMap" > > select > ID, AMOUNT > from > TABLE > where CODE = #code > and ID IN (#ids) > </select> > Support for arrays or list parameter using "IN" keyword > ------------------------------------------------------- > > Key: IBATIS-38 > URL: http://issues.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://issues.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
