I am using the following code:- rs = s.executeQuery("SELECT Field1, Field2, Field3, Field4 FROM XXXXXX " + "WHERE Field1 LIKE String1 AND Field2 LIKE String2 AND Field3 LIKE String3 AND Field4 LIKE String4 " + "GROUP BY Field1, Field2, Field3, Field4");
XXXXXX - table name Field1 thru Field4 are VARCHAR variables and am getting the error on String1 -- View this message in context: http://apache-database.10148.n7.nabble.com/Using-the-WHERE-clause-in-a-ResultSet-tp144994p144997.html Sent from the Apache Derby Users mailing list archive at Nabble.com.