Qualifier null handling is database-dependent.
Some databases require "is null" and some require "= null" while some
will accept both.
You'd either have to explicitly choose the supported type for your
query or (probably better) use "value = $nullValue" and set $nullValue
to null in your use of the qualifier. That should allow Cayenne to
correctly choose the right operator.
On 9/9/05, Gili <cowwo..bs.darktech.org> wrote:
> Hi,
>
> I've declared a SelectQuery in the modeler. The qualifier is set to
> "parent = null" where "parent" is a to-one relationship. Anyway, at
> runtime with logging enabled I can see that "parent is null" is never
> passed onto the SQL query, as a result I am getting results back where
> the parent is non-null. I am invoking the query using:
>
> context.performQuery("DefaultTheme.getRoot", false);
>
> it does not take any parameters. I tried searching the mailing list but
> found no mention of this. Is my qualifier syntax wrong or is something
> wrong with the modeler?
>
> Thank you,
> Gili
> --
> http://www.desktopbeautifier.com/
>
This archive was generated by hypermail 2.0.0 : Fri Sep 09 2005 - 09:31:17 EDT