2004 IR Help Posted August 20, 2006 Share Posted August 20, 2006 By: bpdy9fg - bpdy9fg Can you only have parameters in queries? 2005-01-07 06:05 Hi, I'm new to using jasper .. just wondering when using the sqlQuery tag .. is it only Parameters that can be used as values in the sql text? Can Variables be used? Come to think of it can Variables be constructed using a Parameter? For instance ... if a Parameter (name=sched) is a "Schedule " object, how would I translate the value of Schedule.getStartTime() into the sql query. Any help would be appreciated. Brian By: Teodor Danciu - teodord RE: Can you only have parameters in queries? 2005-01-11 12:24 Hi, Yes, only parameters can be used in the SQL query. If you need to perform some operations on the parameters and supply a derived value to the SQL query then use the <defaultValueExpression> of a dummy report parameter that you place as the last parameter in the list. I hope this helps. Teodor 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