Bugs item #579863, was opened at 2002-07-10 15:55 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=579863&group_id=22866
Category: JBossCMP Group: v3.0 Rabbit Hole Status: Open Resolution: None Priority: 5 Submitted By: Frederik Sauer (fredsa) Assigned to: Nobody/Anonymous (nobody) Summary: EJB-QL w/ dates: BETWEEN, >=, <= Initial Comment: The following does not work (is it supposed to?) in EJB-QL under 3.0.1RC1: WHERE someDateField BETWEEN ?1 AND ?2 The following work-around doesn't work either (this should definately work IMHO): WHERE someDateField >= ?1 AND someDateField <= ?2 One must instead resort to: WHERE (someDateField > ?1 AND someDateField < ?2) OR someDateField = ?1 OR someDateField = ?2 because the >=, <= and BETWEEN operators are not accepted in combination with fields based on java.util.Date ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=579863&group_id=22866 ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Two, two, TWO treats in one. http://thinkgeek.com/sf _______________________________________________ Jboss-development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
