Datagrid - How to pull in rows in smaller portions?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

blckbrry - 26 May 2005 07:09 GMT

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

Reply to this Message

Dinghus - 27 May 2005 00:26 GMT

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.

Reply to this Message

Webmaster Forum / Flash / Data Integration / May 2005

Datagrid - How to pull in rows in smaller portions?