Can anyone see anything wrong with this statement ?
ResultSet res = statement.executeQuery(
"SELECT * "
+ "FROM CAPS_PARTICIPATION_ACTIVITY WHERE EMP_ID = '"
+ sEmp_id + "AND PRTPT_ACTV_ID =" + code_array +
"AND ACTV_DT =" + date_range_array + "'");
It returns 0 records, even though I know there are records matching this criteria. If I run the QUERY one criteria at a time, (say EMP_ID = sEmp_id, or ACTV_DT = date_range_array), it finds the records, but not when I string them together in a compound statement.