Hi friends, In my app I have a CMP Entity Bean representing an exchange rate at a specific date. I created a select methos with following query:
SELECT MAX(o.date) FROM ExchangeRate o WHERE o.listino.id=?2 AND o.currency.id=?2 AND o.date<=?3 Third parameter is a java.util.Date type This method always returns a null value. I'm using mySQL as DBMS. Where am I wrong? Thanks a lot. Filippo View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3921387#3921387 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3921387 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user