String query="SELECT SCOREID FROM score where DATETIME between '08-apr-08' and '10-apr-08'";
works fine in
java but how to give the date using any variable (String/date)
i tried like this, but doesn't work
String h="08-apr-08";
String query="SELECT SCOREID FROM score where DATETIME between "+h+" and '10-apr-08' "
this gives me invalid column name exception
could you people suggest me whats wrong?
thanks in advance