I have a date filed declared in my cmp entity bean,how should I write the finder query to return the records which fall into certain range of dates.
The equivalent DB query is:
select * from table_name where date>date1 and date<date2;
Finder queries are container dependant so we cant help you unless you tell us what container it is.
In Sybase EAServer the finder query would look like
select * from [table] where date > @date1 and date < @date2
Internet Applications Division
in weblogic5.1 u have to give WLQL query in finder method like (& (date >date1) (date <date2)).