Hi to all.
I'm writing a SQL code to extract fields from a database
My DB is MySQL based and i use JDBC connector.

If i try to use a parametric form of IN Syntax ( eg. SELECT name WHERE id IN (1,2,3) ) it works only if the elements of IN parenthesis are passed not in a parameter way.
If i use a syntax like
SELECT name WHERE id IN($P{ID_NAME})
it doesn't work because it shows me only one, and the first, record of the query.
Anyone know how to solve this problem?

Thanks