Re: Using the WHERE clause in a ResultSet

[Bob M]

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.