Arrays

Im starting to work with arrays in Mirth3.0. I want to query a database and return all the values in an array. So far this is what I have came up with. But everytime I call the varaible Mirth just returns the name of the variable. Is there something im missing?





var array = new Array();

var result = dbConn.executeCachedQuery("SELECT "COLUMN" FROM "TABLE" WHERE "" = '" + $('variable') + "'");

var i=0;

while (result.next()) {

var iT = result.getString('1');

array[i] = iT;

i++;

}

channelMap.put('array', array);

Arrays