Flash to DB to Flash 1

[tomhughes]

I am trying to get values from an Access Data Base and pass them to a Flash movie which has text boxes to hold the variables.

I have a single Flash movie. The First frame contains the actionscript :

ifFrameLoaded (1) {
loadVariablesNum ("http:/FilePath.../Courses_Taken.asp?ISID=ISID", 0, "POST"
}

The File Courses_Taken.asp has an SQL Query that depends on the variable "ISID" which is passed through te URL, and one other hard coded value.

If I use the variable "ISID" and the one hard coded value, I do not get any values. However if I use a hard coded value in the place of the variable "ISID" I get values. I suspect the problem is in the timing of the Query, but how can I solve the problem. Is there some other cammand I can use to get the values in the first frame??

 

[billwatson]

Go to

http://www.flashcomponents.net

and download the table component. You just drop this in a movie and it reads and displays an access file. Saves reinventing the wheel.

 

[tomhughes]

Bill - This looks great, but I am using Flash5.0, and not Flash MX.

 

[billwatson]

Ah! Flash 5 then all I can suggest is this tutorial on integrating flash 5 with access

http://www.15seconds.com/Issue/010605.htm?voteresult=4

Hope this helps.

 

[tomhughes]

Thanks Bill - I appreciate your help