Search code examples
listsqliteapache-flexflex-spark

Flex Spark List with SQL Result


I'm trying to populate a spark list component from SQLite in an AIR application

statusList = new ArrayCollection(statement.getResult().data);
myList.dataprovider = statusList;

From the debug session I know the data is structured as statusList->unnamed object->array

<s:List width="100%" height="100%" id="listUploadStatus" dataProvider="{statusList}">
    <s:itemRenderer>
    <fx:Component>
        <s:ItemRenderer>
                <s:Label text="{HOW DO I ACCESS INDIVIDUAL FIELD HERE?}" width="125"/>      
            </s:ItemRenderer>
        </fx:Component>
    </s:itemRenderer>
</s:List>

UPDATE The fields are:

1) NAME 2) IMAGE_URL


Solution

  • Try this :

    <s:List width="100%" height="100%" id="listUploadStatus" dataProvider="{statusList}">
        <s:itemRenderer>
        <fx:Component>
            <s:ItemRenderer>
                    <s:Label text="{data.myAwesomeField}" width="125"/>      
                </s:ItemRenderer>
            </fx:Component>
        </s:itemRenderer>
    </s:List>