I'm actually using the same conversion... were you using mySQL?
Thanks, Aaron
Edson Carlos Ericksson Richter wrote:
Hi!
I've used Dates normally with less than, greater than and between with SapDB. Unique thing I had todo is put a "conversion" in field like:
conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlTimest ampFieldConversion"
then it works for me.
Edson Richter
----- Original Message ----- From: "Aaron Longwell" <[EMAIL PROTECTED]>
To: "OJB User" <[EMAIL PROTECTED]>
Sent: Monday, June 16, 2003 2:42 AM
Subject: addLessThan or addBetween with Dates in mySQL
OJB Experts,
I am using mySQL with OJB to build an event calendar. I need to display 1 month's worth of events. At first, I tried code like this:
criteria.addBetween("EventDate", startDate, endDate);
where startDate and endDate are java.util.Dates. I got no results, even though there are events in the database between those two dates. I retried with a single addGreaterOrEqualThan(). This worked as expected, returning events whose date was on or after the startDate submitted. I then tried the addLessOrEqualThan(). This returned 0 results, even though there are events before the submitted date in the database.
The Javadocs show examples of these commands being used with integers and not dates. Am I wrong to even attempt this? I would prefer not to implement my method an addSQL() call. I would think Date-handling would be automatic with an OJB tool.
Thanks for the help, Aaron
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.489 / Virus Database: 288 - Release Date: 10/6/2003
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
