Hi,
As far as I know, you can just use a 'Hashmap' as parameter type, and "WHERE SearchDate BETWEEN #enddate# and #startdate#" to perform the query on those two parameters. Be sure to add the two dates to the Hashmap parameter using exactly the same names ;-) Regards, Kamiel From: Manu Juyal [mailto:[EMAIL PROTECTED] Sent: Friday, August 31, 2007 7:10 PM To: [email protected] Subject: Sql parameters Hello, I am using a select statement with two parameters: "enddate" and "startdate" In WHERE clause I am using search on the column called "SomeDate". For Example, WHERE SearchDate BETWEEN enddate and startdate. How can I achieve this? It seems I cannot use parameter class for this because it will take only existing columns as parameters and not enddate and startdate.
