private void setAssemblyMatch() { substitutions.put(":assembly_match:", "in (select assembly_id from v4_expt_trial_assembly where trial_id = '" + trialId + "')");
private void setAssemblyMatch() throws SQLException { ResultSet rs = executeQuery(stmt, dbp.getQuery("queryTrialAssemblies", substitutions)); StringBuffer q = new StringBuffer(); boolean first = true; q.append("in ("); while (rs.next()) { if (first) { first = false; } else { q.append(", "); } q.append("'").append(rs.getString(1)).append("'"); } q.append(')'); if (first) { substitutions.put(":assembly_match:", "is null"); } else { substitutions.put(":assembly_match:", q.toString()); }
    private void setAssemblyMatch() {        substitutions.put(":assembly_match:",                          "in (select assembly_id from v4_expt_trial_assembly where trial_id = '"                          + trialId                          + "')");    }