Thanks, but the parameter 'entryrefno' is of numeric type in my table. How
can i pass two different types of values to Map at the same time?
Please reply me. I am struck at this point.
Nate Weiss wrote:
>
> Hi mukhi--
>
> I'm pretty new to this list, but I believe the general solution is to
> make a HashMap and pass that in:
>
> Map params = new HashMap();
> params.entryRefno= myEntryRefno;
> params.someList = someList;
> getSqlMapClientTemplate().insert("insertChoice", params);
>
> In iBatis 3 you also have the option of creating a mapper interface
> class which allows you to pass in multiple params without a map.
>
>
> On 4/11/2010 3:41 PM, mukhi wrote:
>>
>> I am using Spring with Ibatis. I want to pass a sting value and list to a
>> query. How I can do that.
>>
>> My query is as follows
>> INSERT INTO
>> T_ENTRY_ANSWER_ASSOC( ENTRY_REFNO, CHOICE_REFNO )
>>
>> SELECT #entryRefno#,CHOICE_REFNO,
>> FROM T_CHOICE
>> WHERE CHOICE_REFNO IN ( 90,89,93,45,67)
>>
>>
>>
>> in the above query i need to pass two types of parameters.
>> 1. Sting
>> 2.list of values in where clause.
>>
>> How can i do it?
>>
>>
>> What kind of parameter I can pass to call the query. while making call
>>
>> getSqlMapClientTemplate().insert("insertChoice", What parameter goes
>> here?);
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>
>
>
--
View this message in context:
http://old.nabble.com/how-to-pass-two-different-types-of-values-to-query-in-IBATIS-tp28211187p28218461.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
