logo       

Query question: msg#00040

java.jasperreports.general

Subject: Query question

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


<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise