Home Tutorials Forums Articles Blogs Movies Library Employment Press Buy templates

Go Back   ActionScript.org Forums > Desktop, Mobile and non-browser Environments > AIR (Apollo)

Reply
 
Thread Tools Rate Thread Display Modes
Old 07-14-2007, 09:16 PM   #1
handycam
Registered User
 
Join Date: Jul 2007
Posts: 70
Default SQL question

I'm trying to access a local DB file using an Air app. I can successfully create the connection and connect; what I'm really stuck on is displaying the data from my request in a Data Grid.

Using this code I can see my records in the console, but how do I get it into a data grid? It doesn't seem to want to go into an ArrayColleciton.

Code:
function selectResult(event:SQLEvent):void
{
    var result:SQLResult = selectStmt.getResult();
    resultData = result;
    var numRows:int = result.data.length;
    for (var i:int = 0; i < numRows; i++)
    {
        var output:String = "";
        for (var columnName:String in result.data[i])
        {
            output += columnName + ": " + result.data[i][columnName] + "; ";
        }
        trace("row[" + i.toString() + "]\t", output);
    }
}

Last edited by handycam; 07-14-2007 at 09:36 PM..
handycam is offline   Reply With Quote
Reply


Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
question regarding layer jungyung ActionScript 1.0 (and below) 2 10-02-2006 11:57 AM
Multiple answers to 1 question in Flash Quiz? milohound ActionScript 1.0 (and below) 8 02-21-2005 12:11 AM
Swapdepth using txt files and dynamic content for game. superbnerb ActionScript 1.0 (and below) 3 09-22-2004 08:27 PM
List Arrays & SQL primusluta Components 1 06-12-2004 08:00 PM
Game "Time Delay" after question is answered kunafish Gaming and Game Development 1 07-29-2002 08:04 PM


All times are GMT. The time now is 03:46 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Ad Management plugin by RedTyger
Copyright 2000-2009 ActionScript.org. All Rights Reserved.
Your use of this site is subject to our Privacy Policy and Terms of Use.