Hi, I want to query the DB on date. I try to use criteria.addTime(SettingPeriodPeer.STARTING_DATE, year, month, day, Criteria.GREATER_EQUAL); but this generate a bad query string and so it throws an SQLException. I also try to use criteria.add(String, Object, String) method, putting a java.util.Date as Object but it doesn't work neither Which method do I have to use ?? Thanks, Herv� --------------------------------- The generated SQL is like : SELECT setting_period.SETTING_PERIOD_SID, setting_period.SETTING_NUMBER, setting_period.STARTING_DATE, setting_period.ENDING_DATE FROM setting_period WHERE setting_period.STARTING_DATE>=java.util.GregorianCalendar[time=?,areFieldsSe t=false,areAllFieldsSet=false,lenient=true,zone=java.util.SimpleTimeZone[id= Europe/Paris,offset=3600000,dstSavings=3600000,useDaylight=true,startYear=0, startMode=2,startMonth=2,startDay=-1,startDayOfWeek=1,startTime=7200000,endM ode=2,endMonth=9,endDay=-1,endDayOfWeek=1,endTime=7200000],firstDayOfWeek=2, minimalDaysInFirstWeek=1,ERA=1,YEAR=2000,MONTH=10,WEEK_OF_YEAR=?,WEEK_OF_MON TH=?,DAY_OF_MONTH=14,DAY_OF_YEAR=?,DAY_OF_WEEK=?,DAY_OF_WEEK_IN_MONTH=?,AM_P M=?,HOUR=?,HOUR_OF_DAY=?,MINUTE=?,SECOND=?,MILLISECOND=?,ZONE_OFFSET=?,DST_O FFSET=?] ------------------------------------------------------------ To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/> Problems?: [EMAIL PROTECTED]
