Does jasperreports use bind variables?

[ed4becky]

... or string concatenation. if ${P1} = 3, is the query:

 

select type from hospital where id = ${P1}

 

resolved to:

 

select type from hospital where id + ${P1}.toString()

 

or

 

select type from hospital where id = ?

 

with ${P1} bound to ? at run time.

[lucianc]

$P{..} will produce bind variables (query parameters), while $P!{..} will be replaced as text in the query string.

 

You can read this short tutorial page.

 

HTH,

Lucian