Pass an array into a named query's WHERE ... IN ( , , , ...) statement

[pturmel]

Pssssst!

Taking a Dataset and Inserting it to a SQL temp table

If you were using a competent database (the following is PostgreSQL), you can pass java arrays as arguments, and unnest() them in a FROM clause. For an example, I created a table in my psql forum playground called phrases, to be used in a join. When queried by itself, you get this dataset: "#NAMES" "prefix","suffix" "#TYPES" "str","I" "#ROWS","4" "Hello","1" "Good Bye","2" "Welcome to","3" "Whoa!","4" To go with that, in a custom property named lookups, I created the following unbound datase…

and

How to pass WHERE IN [values for int] to named query as parameter

Concur. Just say no to QueryString parameters. Besides, you can pass arrays to "Prep" queries if you have a competent database and JDBC drivers. In this case, the PostgreSQL syntax for runPrepQuery would look like this: SELECT * FROM some_table WHERE some_column = ANY (?)