How to use parameter in query

[ktrinad]

By: Dejan - dnikolov

How to use parameter in query

2003-02-05 23:56

I have the problem using the parameter in query?

When i use:

select * from drzavi where naziv like $P{Drzava}

i get message :

Not supported token at positoin

 

 

 

 

By: Giulio Toffoli - gt78

RE: How to use parameter in query

2003-02-06 04:01

You must use the right sytax:

 

$P!{Drzava} and not $P{Drzava}

 

if the value that you supply have the ' or ".

else you must rewrite your query adding ' or "...

 

select * from drzavi where naziv like '$P{Drzava}'

 

I hope this helps you

Giulio

 

 

 

 

By: Mark Rhodes - mrhodes2

RE: How to use parameter in query

2003-02-06 08:14

I think your problem is your not deleting the query from the sql query box when you compile your report. Jasper needs to resolve the parameters internally.