lundi 22 décembre 2014

Flex App Sqlite Select statement returns [object Object]

I am trying to populate StageWebview.loadURL with the value from the AthleticsURL field in my SQLite database based on the SQL Select statement below. When I trace the variable in the sqlAthResult function, I get:


result: [object Object]


output: null


(null)


Any suggestions on how to return AthleticsURL value? AthleticsURL is a String



private function athleticsData():void
{
stmts.sqlConnection = this.isDbConnected(conn);
stmts.text = "SELECT AthleticsURL FROM DistrictSchools where AthleticsFavs == 1";
stmts.addEventListener(SQLErrorEvent.ERROR, sqlError);
stmts.addEventListener(SQLEvent.RESULT, sqlAthResult);
stmts.execute();
trace("Row requested @athleticsData");
}

public function sqlAthResult(res:SQLEvent):void{
var result:Array = stmts.getResult().data;
var output:String = result.AthleticsURL;
trace("result:" +result);
trace("output: " +output);
trace(ObjectUtil.toString(result.data));
}

Aucun commentaire:

Enregistrer un commentaire