SQL queries & reference variables in flash

[the_seangw]

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

[Ilya]

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

[the_seangw]

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.