ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mukhi <vkstudymater...@gmail.com>
Subject how to pass two different types of values to query in IBATIS
Date Sun, 11 Apr 2010 19:41:53 GMT

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

                    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
View this message in context: http://old.nabble.com/how-to-pass-two-different-types-of-values-to-query-in-IBATIS-tp28211187p28211187.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

View raw message