Jump to content
Changes to the Jaspersoft community edition download ×

How to use parameter in query


ktrinad

Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...