sqlite + flex 4.6 + array doubts -
here flex newbie. i've tested 'answer 2' code
but modified it: throwed in button, purpose populate list data, after being clicked; result half-success, got "[object object]" in list instead of data; how overcome problem? flex 4.6, code follows:
<?xml version="1.0" encoding="utf-8"?> <s:view xmlns:fx="http://ns.adobe.com/mxml/2009" xmlns:s="library://ns.adobe.com/flex/spark" title=""> <fx:declarations> <!-- place non-visual elements (e.g., services, value objects) here --> </fx:declarations> <s:layout> <s:verticallayout paddingtop="10" paddingleft="10"/> </s:layout> <fx:script> <![cdata[ import flash.data.sqlconnection; import flash.data.sqlstatement; import flash.filesystem.file; import flash.filesystem.filemode; import mx.collections.arraycollection; private function getdata():arraycollection { var stmt:sqlstatement = new sqlstatement(); stmt.sqlconnection = new sqlconnection(); stmt.sqlconnection.open(file.applicationstoragedirectory.resolvepath("assets/test.sqlite")); stmt.text = "select one, 2 zero"; stmt.execute(); var result:array = stmt.getresult().data; resultarr = new arraycollection(); if (result) { resultarr.source = result; } return resultarr; } [bindable]private var resultarr:arraycollection = new arraycollection(); protected function button1_clickhandler(event:mouseevent):void { // todo auto-generated method stub getdata(); } ]]> </fx:script> <s:button label="ok" click="button1_clickhandler(event)"/> <s:list width="302" height="234" dataprovider="{resultarr}"></s:list> </s:view> thanks whoever wants me.
your getting [object object] because data being returned has multiple values (columns 1 , two). need tell application want displayed.
try setting labelfield parameter , see get:
<s:list width="302" height="234" dataprovider="{resultarr}" labelfield="one"></s:list>
Comments
Post a Comment