failing query (no results) using dropdowns

[sjoerd.jump]

Hello Guys,

 

i have a question about a query that is based on 2 paramaters.

Both parameters are dropdowns ($P{dropdown1} and $P{dropdown2})

$P{dropdown1}
select naam from table1 join table2 using (id) order by naam 

$P{dropdown2}
select ht from table1 join table2 using (id) where naam = $P{dropdown} and ht not in (select ht from negeren_ht)

some of my code that fills the report:
and (naam = $P{dropdown} and ht = ANY (array[$P{dropdown2}]))

 

I suspect the problem is with ht =  ANY (array[?]))

 

The output according to the logfile is:

and (naam = ? and ht = ANY (array[?]))

2013-11-04 11:59:14,196 DEBUG JRJdbcQueryExecuter,pool-1-thread-96:396 - Parameter #1 (dropdown of type java.lang.String): component

2013-11-04 11:59:14,196 DEBUG JRJdbcQueryExecuter,pool-1-thread-96:396 - Parameter #2 (dropdown2 of type java.lang.String): [sub1, sub2, sub3 totaal]

I dont know what im doing wrong, the query gives the correct output when i run it in pgAdmin, but it fails in Jasperserver...

Any ideas?

 

cheers, 

 

sjoerd