Query with LIKE %...%

[asder99]

Hi!

I've got a problem with a query.

 

The original query is this:

Select id, name, description
from table_01
where name like '%roger%'

I need to use this query in iReport, but "roger" should be a variable.

So I write:

Select id, name, description
from table_01
where name like '%$P{px_name}%'

But it doesn't work.

Where can I find a guide to insert correctly an iReport variable in a query?

 

Thanks!

[mpetek]

Try the $P!{parameter_name} syntax, this will pass the parameter value directly.

regards

[asder99]

It works, thanks a lot!

 

But, just for information, what does "$P{parameter_name}" (without exclamation mark) pass?