cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Frank" <faro...@hotmail.com>
Subject Re: How do I query on null or blank field?
Date Wed, 07 Mar 2007 16:20:18 GMT
Thanks Mike,

That worked.

Frank
----- Original Message ----- 
From: "Mike Kienenberger" <mkienenb@gmail.com>
To: <user@cayenne.apache.org>
Sent: Tuesday, March 06, 2007 3:02 PM
Subject: Re: How do I query on null or blank field?


> 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