[flexcoders] SQLite help Flex 3 Beta 2

[Nick Collins]

Okay, I'm trying to execute a query on my local SQLite database using
the following code, but am not having any luck. When I run the same
SQL code in Cristophe's SQL Admin app, it works fine, returning the
two records. However, when I run it here with my code, it returns a
null as the result value. What am I doing wrong?


/** CODE BEGIN**/

public function getContributorsList(orgID:int):void
                {
            stmt.sqlConnection = sqlConnection;
                        stmt.text = "SELECT * FROM CONTRIBUTORS WHERE ORGID = 
:orgID ORDER
BY LAST_NAME, FIRST_NAME";
                        stmt.parameters[":orgID"] = orgID;
                        stmt.addEventListener(SQLEvent.RESULT, resultHandler);
                        stmt.addEventListener(SQLErrorEvent.ERROR, 
errorHandler);
                        stmt.execute();
                }
                
private function resultHandler(event:SQLEvent):void
                {
                    var result:SQLResult = stmt.getResult();
                    var numResults:int = result.data.length;
                    for (var i:int = 0; i < numResults; i++)
                    {
                        var row:Object = result.data[i];
                        var output:String = "ContribNum: " + row.CONTRIBNUM;
                        output += "; First Name: " + row.FIRST_NAME;
                        output += "; Last Name: " + row.LAST_NAME;
                        trace(output);
                    }
                }