ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mukhi <vkstudymater...@gmail.com>
Subject Re: how to pass two different types of values to query in IBATIS
Date Mon, 12 Apr 2010 14:24:35 GMT

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-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message