JDBC - Setting Values on PreparedStatement

Hi All,
      I have had a tour around the Net and can't seem to find an
answer/example of this.

Have a simple SQL statement
SELECT * FROM ERORPF WHERE ERORLANG IN ('E', 'N', 'D')
The contents of the IN predicate can vary from 1 to 10 items, hence my
question.

I set this in a PreparedStatement

PreparedStatement pstmt = con.prepareStatement("SELECT * FROM ERORPF WHERE
ERORLANG IN (?)");

But when it came to replacing the ? with the required values, I hit my
problem.
I tried (perhaps optimistically) just to see if it would accept parameters
in the following format, but no joy.

String langs = "'" + lang1 + "' , "  + "'" + lang2 + "'";
setString(1, langs);

How can you pass a variable amount of values to the IN predicate?


regards


James O'Sullivan
Senior Technical Consultant
email: josulli4@xxxxxxx
Office: +44 1252 536681
Fax: +44 1252 534022
www: www.csc.com
Based at: Tower 2, Floor 2, Royal Pavilion, Wellesley Road, Aldershot,
Hampshire, GU11 1PZ

CSC Corporation Limited: No. 1812179.
All registered office addresses: Royal Pavilion, Wellesley Road, Aldershot,
Hampshire, GU11 1PZ. Registered in England.


--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------