Eric,
in that case, please feel free to create an issue at http://jira.codehaus.org/browse/CASTOR, and we'll try to be as helpful as possible.
Werner
Eric Anderson wrote:
Yea it really shouldn't be that hard right? ..... Ok project number 4.
[EMAIL PROTECTED] 05/09/05 1:45 PM >>>
Eric,
you could of course provide us with a patch that enabled native support
for the NVL function .. ;-). Just an idea though.
Werner
Eric Anderson wrote:
Worked nicely... not as clean as it could be, because if I change
the
mapping I have to remember to change the code. But it works. Thanks
[EMAIL PROTECTED] 05/06/05 2:01 AM >>>
Hi Eric,
OQL do not offer a NVL function. The only way that I can see is using
the SQL passthrough feature with the: CALL <sql-select-statment> AS <classname> syntax.
Ralf
Eric Anderson schrieb:
I looked through the documentation... but couldn't see anywere where
it
mentions this.
How do I do a query like this
WHERE (nvl(no_of_doses, 0)+nvl(extra_doses, 0)+nvl(adjusted_doses,
0)
-nvl(under_doses, 0)-nvl(shared_doses, 0)-nvl(wasted_doses, 0)
-nvl(given_doses, 0))>0
