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



Reply via email to