Formulas and null values

jsp1611 · **Joined:** Mon Dec 08, 2003 8:09 am **Posts:** 25

Hi there,
I haven't been able to find any information on the forums about this, or in "Hibernate in action": is it possible to have a formula (used in a Hibernate mapping file) that may return a null value (no rows)? Or must formulas always return at least 1 row? In addition, is it possible to reference a formula field in a HQL query, as in:

FROM SomeObject where fieldOne = "foo" and fieldTwo = "bar";

Where fieldOne/fieldTwo is generated from a formula and may be null?

Cheers
Jon

jsp1611 · **Joined:** Mon Dec 08, 2003 8:09 am **Posts:** 25

So, no one knows what happens if you have a formula that returns 0 rows?

emmanuel · **Posted:** Mon Sep 19, 2005 5:08 am

a formula return a value null or not, not several rows