Problem using setString in PreparedStatement

[sikar]

Hi,

I am using PreparedStatement and my query is like this:

Select all_dest, city_type from TableA
where city_type in (?) " ;

In the PreparedStatement, I am using a String to provide value for city_type

pstmt.setString(1, strCityType);

Now this strCityType has value = 'I', 'T', 'A';

On executing the query I am getting SQLException, Error Code 302.

Any kind of help to solve this problem will be highly appreciated. I am in urgent need to solve this problem.

Thanks
Sikar

 

[timw]

I've never used prepared statements like this but I would expect you'd have to explicitly put a placeholder for each item, thus:-

Select all_dest, city_type from TableA
where  city_type in (?,?,?);

with setting the params like this:-

pstmt.setString(1, "I");
pstmt.setString(1, T");
pstmt.setString(1, "A");

Tim

 

[timw]

... or even

pstmt.setString(1, "I");
pstmt.setString([b]2[/b], T");
pstmt.setString([b]3[/b], "A");

Tim