4 Sep
2001
4 Sep
'01
3:55 p.m.
Horrible bodgy hack: does <dtml-var "Integer(Float(field))"> work? I don't know why Oracle numbers get promoted into Long's and Float's, but I agree it's annoying. At 17:47 04/09/01 +0200, Stig-Arne Nordin wrote: <snip>
I know the NVL trick, it works. Almost. It yields 0.0 for an integer, I want it to be 0. I tried Round(nvl(optional_number, 0), 0) got me 0.0 for null