• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Jasper - Query with parameters

 
Pablo M´┐Żller
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I'm starting to use jasper and I need to pass some parameters to a query for the where clause, but if the parameters are null (or "", etc) I don't want the where to be there. Is there any way to do this without providing the whole query as a parameter?
Thanks,
Pablo
 
Marco All
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I love to recover old "discussion"

I use JasperServer and iReport.

I've a query like: "SELECT * FROM contact WHERE code='01' " and I would like that the user could decide to enter the code 01 or the code 02 before the launch.

I've tried to use the input control but that was a good way to do that...


Do you have any suggestion?
 
Martijn Verburg
author
Bartender
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Marco,

We try to NotWakeTheZombies. Can you post your problem in a new thread please
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic