did you check the type of value you are passing to the list? you may be
passing string type values to the list.
devver wrote:
>
> Thanks for the reply (sorry: managed to reply twice). It's IB v2.
> An older version of IB sounds feasibly yet we have sql maps that use
> similar constructs, i.e n
to " WHERE CHOICE_REFNO IN( 90,89,93,45,67 )"
This would work fine
François Schiettecatte wrote:
>
> I think Mukhi is trying to pass a string and an array of numbers, the
> string being the entryRefno and the list of nunbers to be added to the
> IN() clause of the SELECT statement in
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
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
