yes,
It's ok, the problem was with the column types..
In my database, columns types are 'char(n)' and not varchar.
So, each time I want to compare values.. I have to set explicitely something
like that :
rpad (#ids[]#,36,' ')
If I do not set param like this, it doesn't work..
Maybe there's a be
l Message-
From: jeb001 [mailto:[EMAIL PROTECTED]
Sent: Friday, July 28, 2006 9:21 AM
To: user-java@ibatis.apache.org
Subject: Re: help problem with select request using 'in' where clause
Hi,
Thanks for your help.. but something still drives me crazy..
It seems that I sould pass a
From: jeb001 [mailto:[EMAIL PROTECTED]
Sent: Friday, July 28, 2006 9:21 AM
To: user-java@ibatis.apache.org
Subject: Re: help problem with select request using 'in' where clause
Hi,
Thanks for your help.. but something still drives me crazy..
It seems that I sould pass a "java.uti
Hi,
Thanks for your help.. but something still drives me crazy..
It seems that I sould pass a "java.util.Map" object and not a
"java.util.List" in my select tag..
So, I did that :
// that list contains ids I want to add in 'in' clause.
List params = new ArrayList() ;
// I put it in a Map.
20
PM
To: user-java@ibatis.apache.org
Subject: help problem with select
request using 'in' where clause
Hi,
I have to generate a request using 'in'
where clause.
The request I have to launch is like this :
Select * from table where id in ('1'
jardin
[mailto:[EMAIL PROTECTED]
Sent: Thursday, July 27, 2006 7:20
PM
To: user-java@ibatis.apache.org
Subject: help problem with select
request using 'in' where clause
Hi,
I have to generate a request using ‘in’
where clause.
The request I have to launch is like this :
Sel
Hi,
I have to generate a request
using ‘in’ where clause.
The request I have to launch
is like this :
Select * from table where id
in (‘1’, ‘2’, ‘3’);
But I don’t what kind
of parameter I should add.
This is my xml file :
