cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Frank" <faro...@hotmail.com>
Subject How do I query on null or blank field?
Date Tue, 06 Mar 2007 19:34:01 GMT
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message