Setting query as parameter problem!!!

[p_a]

Hello all,

 

I am working with iReport2.0.1 and wanna send query as a string to iReport.So I define a string parameter and set the query as its default value:

 

"select * from test" as a default value for $P{dbQuery},but the problem is the iReport database could not understand String parameter and give me an exception!!!!!

 

It says :

{You have an error in your sql syntax;check the manual that corespondens to your SQL server version for the right syntax to use near "select * from test" !!!}

 

Can anyone please tell me where did I wrong???????

 

Thank you,

Pegah

[vinays84]

use $P!{dbQuery}

[p_a]

Hi vinays84,

 

Thanks for your help.It works:P