flash form w/sql DB 2

[natedeia]

i am having a hard time understanding something about sql and how it works with a flash form i want.
a friend of mine will be doing the DB and i am going to work on a flash form. this form will not submit any information, instead it will GET information and populate about 5 fields. on my homepage it will have a space to enter a 5 digit # that will open a new window with my flash swf in it and get the information for a particular record # in the DB.
Question is: How would it work with the Flash page? Would I have to create a new swf each time I need to have one of these pages call information from the DB?
I am confused.

 

[pixl8r]

Here is one way you could do it:

Create your flash form with whatever fields you require.

Set the Var: value in the Properties pallette for the text box to _root.yourDBVariableName.

Your Flash movie will have to reside in some kind of Server side language page. I will use asp as my example.

Set your connections etc just as you would if displaying the information in a regular ASP page.

Define your variable(s): <% yourDBVariableName = rs(&quot;variableName&quot%>

In the Object/Embed code for the flash movie just append the variable to the .swf address. (<PARAM NAME=movie VALUE=&quot;yourMovie.swf?yourDBVariableName=<%=yourDBVariableName%>&yourDBVariableName2=<%=yourDBVariableName2 etc...)

Good luck!

Wow JT that almost looked like you knew what you were doing!