SQL queries & reference variables in flash

I have generator, and an access database.

If I were to query "SELECT * FROM [tablename]", and there were more than one entry for the *, such as a table like below:

[tablename]
Num | Color | size
-----------------------
1 | blue | large
2 | red | small
3 | green | medium
4 | orange | tiny


since I query'd " * " then I would theoretically get back the whole table. How would I reference each individual element?

Also how would I perhaps detect how many elements were taken out, and then report back to find out the number of elements in the list?

Thanks,
Sean

Lets say that you have simple script like

Set RS = Server.CreateObject("ADODB.Recordset")
MyConnStr ="DBQ=C:\path\name.mdb ;DRIVER={Microsoft Access Driver (*.mdb)}"
sql = "Select * from tablename"
RS.Open sql, MyConnStr, , , adCmdTable
RS.MoveFirst

So after it, for example
RS("color") will return "blue" and RS(2) - "large"

And after
RS.MoveNext

RS("num") will return "2" and RS(1) - "red"

Hope it will help :)

I understand that much, what I want is to be able to set a data source in generator and have the flash animation reference a variable for each row in the animation or something like that.