all groups > flash data integration > may 2005 >
You're in the

flash data integration

group:

Datagrid - How to pull in rows in smaller portions?



Datagrid - How to pull in rows in smaller portions? blckbrry
5/26/2005 12:00:00 AM
flash data integration: I have a mysql database with say 300 rows. Datagrid takes too long to show them
(mysql --> php --> flash), and is too processor intensive.

How do have the datagrid only pull in a portion of the records and then allow
the user to call for the next group of records?

Any ideas would be great!!!! Thank you,

rw
Re: Datagrid - How to pull in rows in smaller portions? Dinghus
5/26/2005 11:26:50 PM
Tell me how to get anything into a datagrid and I can tell you how to do this
part of it. :)

The only way I can get a datagrid to show data is to use "additem". Data
binding, xml, arrays, none of that works for me.

However, to do what you want is simply pagination. Have buttons for "FWD" and
"REV" (or whatever) and then when say FWD is clicked you send a request to the
PHP script asking for the next X number of rows starting with Y (the last row
being displayed right now). Do your query and then return the data.
AddThis Social Bookmark Button