hi all,i am shumaiza,
i am using
servlets,and database access,
i have one date column named ticket_time in a table.
now i want to use this date column in my select statment's where clause in my class, but it gives error:
"java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression "
In table values of ticket_time column are in this format :
01-Sep-01
my select statment and some code in my class are below:
String str_t_time = req.getParameter("param");
rs = stmt.executeQuery("select * from Tick WHERE ticket_time = " + "'" + str_t_time +"'" );
my class is working fine if i remove ticket_time and use any other column in where clause.
but i need to search by date.
plzz help.
tahnx in advance.