allmendinger Posted June 13, 2012 Share Posted June 13, 2012 I have designed an iReport with one parameter $P{WhereClause} and my sql is as follows Select * from qry_StockBalance Where $P!{WhereClause} When I run in iReport the parameter box pops up and I type inBalance > 1000Balance < 1000These both work fine. I upload to JasperServer and add an input control to link to the WhereClause parameter. When I run the report the parameter box pops up and I type in the followingBalance < 1000This WorksIf I type inBalance > 1000This does not work and I get the following; The server has encountered an error. Please excuse the inconvenience.An error has occurred. Please contact your system administrator. (5321) Any help please. Link to comment Share on other sites More sharing options...
federico.cattozzi Posted June 14, 2012 Share Posted June 14, 2012 It could be useful if you opened the text of the exception and read the cause.I think it is a limitation of the filter to prevent SQL injection.Post Edited by helyair at 06/15/2012 08:28 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now