I'm trying to get ArrayCollection mapped to an array using the Blazeds turnkey
sample
code. In the sqladmin example, they are creating a List object in the Java
code by
executing the SQL query and storing it like this:
// relevant code...
while (rs.next()) {
row=new HashMap();
for (int i = 1; i <= colCount; i++) {
row.put(rsmd.getColumnName(i), rs.getString(i));
}
list.add(row);
}
}
Then they put this result in a dataGrid:
<mx:DataGrid id="dg" dataProvider="{resultSet}" width="100%" height="100%"/>
and the following method.
private function resultHandler(event:ResultEvent):void {
resultSet = ArrayCollection(event.result);
}
I'd like to display the same data in a chart, but I don't know how to do this.
What I'd like
to do is something like this:
//pseudo code
Horizontal Axis (x) = Data from Column 1
Vertical Axis (y) = Data from Column 2
..or something like that. Anyone know what class the HashMap/List is sending
back so
that I can convert the info into Dates or numbers or somethow get it to show up
on the
chart?
I was trying something like this, but it doesn't work:
var axisArray:ArrayCollection = new ArrayCollection;
for each (var obj:Object in resultSet) {
var f:Number = new Number(obj);
result.addItem(f);
}
// axis data provider = axisArray