eveType2 is a String variable i.e. String eveType2 = "......
I dont think i can use setString as i am not using a preparedstatement here. I think its somthing to do with the way i do the quotations?
No worries, all done, done it like
"WHERE Event_Name='" + eveType2 + "'";
cheers for the help
If the statement used is the one shown, yes you can.
And you should worry, doing it that way opens you up to all sorts of possible errors (and malicious attacks).
Edit: As I said earlier, modify it to use PreparedStatement.