Displaying a list of data from the Database

[JRBT]

Greetings my friends!

Here's the scenario:

I had built an ASP rental web application a while back and I would like to upgrade my front end from HTML to FlashMX. I need to do this because I am tired of fishing through 1200 lines of ASP/HTML to change the littlest thing!

I have everything under control and running smoothly but one part: the part where (for example) a complete list of all properties in the inventory are displayed. In fact, I have no idea how to let Flash handle multiple record sets since each record set would have the same set of variable names...

What is the general way to display multiple record sets?

Do I need one of them there fancy data table components?

If anyone has displayed lists of data, please give me some insight to your typical procedure.

Thanks!

[freddycodes]

Well let's start with getting the data into Flash. Since you are using ASP, the free php remoting solution is not an option, you are pretty much left with creating XML to holds the records. You would need to use the Flash MX XML object to get the data into flash, at which point, you would parse the xml data into some sort of recordset, you could even use the RecordSet object that comes with the free remoting components. http://www.macromedia.com/software/flashremoting/downloads/components/

Next you would need to devise a nice way to loop through your results and create a display using most likely movie clips. I have written a datagrid component. It works but I haven't worked on it for a while. T ouse it you just need to get your data in to a Flash RecordSet object. If you want to check it out you can see a sample here.
http://www.flashcomponents.net/component.cfm?nav=2&id=245

There are some threads in this forum about XML, you can start there