problem with between criteria

2006-08-18 Thread Mike Perham
I'm using crit.addBetween(invoke_date, new Timestamp(startDate.getTime()), new Timestamp(endDate.getTime())); The problem is that that between does not have a Field API like addFieldBetween so I need to use the raw column name. Is there any reason why this API is missing? mike

Re: problem with between criteria

2006-08-18 Thread Mike Perham
Carlos, that's odd. I just noticed that the Criteria APIs seem to have a pattern where they allow either raw columns or the field name and the field name was not working for me. Unfortunately I just moved this code over to use a raw SQL query so I can't get you any error messages. Thanks