[jira] Commented: (IBATIS-38) Support for arrays or list parameter using "IN" keyword

["Roberto Rabe (JIRA)" <ib...@incubator.apache.org>]

     [ 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