Re: Query question

Hi,

You need to use the P!{param_name} syntax.
Check the supplied "/demo/samples/query" sample.

If you have furter questions, please log into www.jasperforge.org forums 
and post them there.
Soon this mailing list will be made read-only as we moved our project 
home to JasperForge.

Thank you,
Teodor


Marty Phee wrote:
> I have a query like below:
>
> select *
> from table1
> where field1 in( $P{subselect} )
>
> I'd like to pass in the $P{} a select field2 from table2, but it's not 
> working.  I'm guessing that it's putting in "select field2 from table2" 
> with the quotes and it's failing.
>
> Is there a way to pass in a string that won't be quoted?
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> jasperreports-questions mailing list
> jasperreports-questions-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@xxxxxxxxxxxxxxxx
> https://lists.sourceforge.net/lists/listinfo/jasperreports-questions
>
>   


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV