Re: >> load 500 by 500 from db in flash

On Oct 19, 2007, at 8:29 AM, CARABUS-Plus wrote:

> 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 =20
> result ?
> Thank you
>
> myFlashSQL.Execute("SELECT * FROM NP_socs_nancy WHERE soc_09 =3D
> \""+categ_var+"\" ORDER BY soc_01");
>
>
> Laurent
>
>
> And the listener :
>
>
> var myListener1:Object =3D new Object();
> myListener1.dataLoaded =3D function(success:Boolean, xmldata:XML) {
>     if (success) {
>         trace(xmldata);
>         if (comStatus =3D=3D "loading") {
>             display.removeAllColumns();
>             display.columnNames =3D ["Sp=E9cialit=E9", "Nom", "Ville"];
>             display.getColumnAt(0).width =3D 120;
>             display.getColumnAt(1).width =3D 100;
>             display.getColumnAt(2).width =3D 115;
>             var dat:Array =3D new Array();
>             _root.finder_txt.text =3D "il y a
> "+xmldata.firstChild.childNodes[3].childNodes.length+" r=E9ponses";
>             for (var i:Number =3D 0;
> i<xmldata.firstChild.childNodes[3].childNodes.length; i++) {
>
> dat.push({Sp=E9cialit=E9:unescape(xmldata.firstChild.childNodes=20
> [3].childNodes[i]
> .childNodes[14].childNodes),
> Nom:unescape(xmldata.firstChild.childNodes[3].childNodes=20
> [i].childNodes[4].ch
> ildNodes),Ville:unescape(xmldata.firstChild.childNodes[3].childNodes=20
> [i].chil
> dNodes[8].childNodes),Tel:unescape(xmldata.firstChild.childNodes=20
> [3].childNod
> es[i].childNodes[9].childNodes),Fax:unescape=20
> (xmldata.firstChild.childNodes[3
> ].childNodes[i].childNodes[10].childNodes),CP:unescape=20
> (xmldata.firstChild.ch
> ildNodes[3].childNodes[i].childNodes[7].childNodes),
>
> Rue:unescape(xmldata.firstChild.childNodes[3].childNodes=20
> [i].childNodes[6].ch
> ildNodes),eMail:unescape(xmldata.firstChild.childNodes[3].childNodes=20
> [i].chil
> dNodes[11].childNodes),
> lat:unescape(xmldata.firstChild.childNodes[3].childNodes=20
> [i].childNodes[16].c
> hildNodes),lon:unescape(xmldata.firstChild.childNodes[3].childNodes=20
> [i].child
> Nodes[17].childNodes),lic:unescape(xmldata.firstChild.childNodes=20
> [3].childNod
> es[i].childNodes[19].childNodes)});
>             }
>             display.dataProvider =3D dat;
>         } else if (comStatus =3D=3D "sending") {
>             msg =3D "Data Sent Successfully. You can now reload!";
>         }
>     }
> };
> _______________________________________________
> Flashcoders mailing list
> [email protected]
> http://chattyfig.figleaf.com/mailman/listinfo/flashcoders


_______________________________________________
Flashcoders mailing list
[email protected]
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders