Re: How do I query on null or blank field?

• Previous message: Frank: "How do I query on null or blank field?"
• In reply to: Frank: "How do I query on null or blank field?"
• Next in thread: Frank: "Re: How do I query on null or blank field?"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

orExp(
ExpressionFactory.matchExp("ASSIGNED_ROOM_BED", null),
ExpressionFactory.matchExp("ASSIGNED_ROOM_BED", "")
)

On 3/6/07, Frank <farocc..otmail.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

• Next message: Peter Schröder: "AW: Help: getting NPE at ObjectStoreGraphDiff.preprocess"
• Previous message: Frank: "How do I query on null or blank field?"
• In reply to: Frank: "How do I query on null or blank field?"
• Next in thread: Frank: "Re: How do I query on null or blank field?"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Tue Mar 06 2007 - 15:03:24 EST