cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Kienenberger" <mkien...@gmail.com>
Subject Re: How do I query on null or blank field?
Date Tue, 06 Mar 2007 20:02:44 GMT
orExp(
ExpressionFactory.matchExp("ASSIGNED_ROOM_BED", null),
ExpressionFactory.matchExp("ASSIGNED_ROOM_BED", "")
)

On 3/6/07, Frank <farocco@hotmail.com> wrote:
> Hello,
>
> Using the ExpressionFactory, I am trying to locate records based on this sql:
>
> WHERE TYPE_ADMIT = '{s_admittype}' AND
> (active = 1) AND (LEN(LTRIM(ASSIGNED_ROOM_BED)) = 0) OR
> TYPE_ADMIT = '{s_admittype}' AND (active = 1) AND (ASSIGNED_ROOM_BED IS NULL)
>
> Is ExpressionFactory the best way to do this?
> I cannot seem to limit my records based on a field that can be blank or null.
>
> Thanks for the help.
>
> Frank

Mime
View raw message