you may also try the expression.fromString with the sql-skripting language of cayenne: http://cwiki.apache.org/confluence/display/CAYDOC/Scripting+SQLTemplate
http://cayenne.apache.org/1_2/grammar/ExpressionParser.html wich seems to be a dead link! -----Ursprüngliche Nachricht----- Von: Frank [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 6. März 2007 20:34 An: [email protected] Betreff: How do I query on null or blank field? 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
