Setting variable based on value of DB field

[evalentine]

I am trying to set the value of a variable based on the value of the database field. The field is an integer and the variable is string.

I have tried :

$F{rts_status}.equals( 5) ? ($V{status}.equals( 'Closed' ):$V{status}.equals( 'Open' ))

but I am getting the error 'Invalid character constant'.

 

Any suggestions?

Thanks.

[slow]

:)

i think you have little problems with java language  :)

try this...
in the variable expression set:

$F{rts_status}.equals( 5) ?"Closed":"Open"

 

______________________________
if it works... KARMA point please!    : ) 

[evalentine]

I drink coffee but do not do Java!

$F{rts_status}.equals( 5) ?"Closed":"Open"

rts_status is integer, how do I convert it to a string for .equals?

 

Thanks for your help.

[slow]

if $F{rts_status} is an Integer then use:

 

$F{rts_status}.intValue()==5 ?"Closed":"Open"

 

Have you ever tasted the Italian coffe?  :)

______________________________
if it works... KARMA point please!    : ) 

 

[evalentine]

It is working now!

Thanks.