[Flashcoders] >> load 500 by 500 from db in flash

[CARABUS-Plus]

Im using FLASHSQL to load data in flash from php db

Theres is too much data to load, how can I do to load 500 by 500 result ?
Thank you

myFlashSQL.Execute("SELECT * FROM NP_socs_nancy WHERE soc_09 =
\""+categ_var+"\" ORDER BY soc_01");


Laurent


And the listener :


var myListener1:Object = new Object();
myListener1.dataLoaded = function(success:Boolean, xmldata:XML) {
    if (success) {
        trace(xmldata);
        if (comStatus == "loading") {
            display.removeAllColumns();
            display.columnNames = ["Spécialité", "Nom", "Ville"];
            display.getColumnAt(0).width = 120;
            display.getColumnAt(1).width = 100;
            display.getColumnAt(2).width = 115;
            var dat:Array = new Array();
            _root.finder_txt.text = "il y a
"+xmldata.firstChild.childNodes[3].childNodes.length+" réponses";
            for (var i:Number = 0;
i<xmldata.firstChild.childNodes[3].childNodes.length; i++) {
                
dat.push({Spécialité:unescape(xmldata.firstChild.childNodes[3].childNodes[i]
.childNodes[14].childNodes),
Nom:unescape(xmldata.firstChild.childNodes[3].childNodes[i].childNodes[4].ch
ildNodes),Ville:unescape(xmldata.firstChild.childNodes[3].childNodes[i].chil
dNodes[8].childNodes),Tel:unescape(xmldata.firstChild.childNodes[3].childNod
es[i].childNodes[9].childNodes),Fax:unescape(xmldata.firstChild.childNodes[3
].childNodes[i].childNodes[10].childNodes),CP:unescape(xmldata.firstChild.ch
ildNodes[3].childNodes[i].childNodes[7].childNodes),
                   
Rue:unescape(xmldata.firstChild.childNodes[3].childNodes[i].childNodes[6].ch
ildNodes),eMail:unescape(xmldata.firstChild.childNodes[3].childNodes[i].chil
dNodes[11].childNodes),
lat:unescape(xmldata.firstChild.childNodes[3].childNodes[i].childNodes[16].c
hildNodes),lon:unescape(xmldata.firstChild.childNodes[3].childNodes[i].child
Nodes[17].childNodes),lic:unescape(xmldata.firstChild.childNodes[3].childNod
es[i].childNodes[19].childNodes)});
            }
            display.dataProvider = dat;
        } else if (comStatus == "sending") {
            msg = "Data Sent Successfully. You can now reload!";
        }
    }
};
_______________________________________________
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders