Muzaffer Dogru wrote: > "SELECT * FROM table WHERE table.Date BETWEEN :dateStart AND :dateEnd" > :dateStart and :dateEnd are variables I put as parameters into the > ClassMethod. They are from the type java.sql.date.
Somewhere they need to be converted to Cache' horolog dates. > In the database I have 2004-08-13 2004-08-13 = 59760. > How can I compare the java.sql.date with the dates in the database? Please post the formal parameters of your classmethod. They could be the wrong type. I'm not clear on how the binding works. It could be that you need to convert explicitly.
