Can you only have parameters in queries?

[2004 IR Help]

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