Arraycollection conversion to chart data

[Solerous]

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

[Gaurav J]

You need to add series to your chart and then assign the data to the series.

I recommend looking at
[url]http://www.quietlyscheming.com/blog/charts/chart-sampler/[/url]

and the charting documentation and examples.

Thanks,
Gaurav

[Solerous]

yes, it seems that I was messing up in assigning the results to the various
axis definitions. I assumed the data wasn't there, but it really was. I
didn't need this loop at all:

var axisArray:ArrayCollection = new ArrayCollection;
for each (var obj:Object in resultSet) {
var f:Number = new Number(obj);
result.addItem(f);
}

just assigning the data correctly:

series1.dataProvider = resultSet;
series1.xField="TIME";
series1.yField="VALUE";

Thanks for the help!