Vector idsOut = new Vector();
PreparedStatement statement = null;
ResultSet resultSet = null;
// construct the SQL statement
DynamicQuery sql = new DynamicQuery(selectSQL);
appendWhere(sql,name,qualifiers);
appendIn(sql,name,idsIn);
appendOrderBy(sql,qualifiers);
try
{
log.debug(sql.toString());
statement = sql.buildPreparedStatement(connection);
resultSet = statement.executeQuery();
while (resultSet.next())
idsOut.addElement(resultSet.getString(1));//("PUBLISHER_ID"));