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

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 result ?
> Thank you
> 
> myFlashSQL.Execute("SELECT * FROM NP_socs_nancy WHERE soc_09 =
> \""+categ_var+"\" ORDER BY soc_01");

My SQL is rusty, but assuming you are using MySQL (no pun there...):

SELECT * FROM NP_socs_nancy WHERE soc_09='foo' ORDER BY soc_01 LIMIT 1, 500;

The LIMIT command uses [offset, max rows], so LIMIT 1, 500 would start 
at row 1 and return 500 rows from the db.  You can increment the offset 
when the data has parsed successfully and query again.

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