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
[email protected]
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
