Mutltiple Results

Im trying to query a database that returns multiple rows. I want to put the results into an array and interate through the array. So far here is what I have. I am using mirth 3.0. Does anyone know of a way?



"SELECT V, VE FROM Table WHERE F = '" + $('var') + "' AND M_T = '" + $('var2') + "'AND(F_V = '" + $('var') + "' OR isnull(F_V, '') = '')")





while(query.next())

{

var r = query.getString('0');

var array = new Packages.java.util.ArrayList();

params.add(results);

channelMap.put("ARRAY",array)

query.close();

dbConn.close();



}

Mutltiple Results