recordset sent to flash

[skitzer]

I don't know the best way to do this.  I want to load data from my database and be able to scroll through the records using buttons in my Flash form.  I don't think it is optimal to keep querying the database on every button click, but I'm not sure how to pass an entire recordset back to flash.  I am considering using a linked list.  Someone please give me some advice as to what's the best way to accomplish my task.  Thanks.

[Ronald Wernecke]

Hi Skitzer,
how large are these recodsets?
If it is rather low or medium sized blocks, you can transfer the data via XML.
If you want to do it with advanced techniques, have a look into AMFPHP

[skitzer]

Hey.
I don't think they'll be anymore than 10 records........

I'm using ASP to read/write to the database.  Isn't there a way to do it using that?

[Jorge Solis]

For a simple way, pass the entire recordset as name/value pairs, check http://www.flash-db.com/Tutorials/loading/

Jorge