Hi,

I've been doing alot of flash database interactive stuff recently and i use a mac so all stuff should be mac ie5 and ns4.7 complient and here are a few tips...

1. loaded variables can't always be used in the same frame they are loaded in so do a little looping frame to check if they are loaded before evaluating

2. all loaded vars need to be url encoded

3. when evaluating number variables in flash either evaluate them as a string or convert to them to an ascii number, i don't know why but this fixes the evaluation on macs.

4. remember unless the target is defined loaded variables go to the timelime that calls them. if your not sure if they are going to your target use a dynamic textbox to display the results.

5. we use php and mySQL as the data source and it works on all recent browsers and platforms

6. remember if your movie is receiving the number variables in the right place but not evaluating them correctly convert them to ascii and evaluate then as ascii it's the only way i've found to guarantee compatibility.

7. We also discovered by looking at the unix web logs that flash sometimes uses GET even when POST is specified. If you print the variables sent to the server you can see, i seem to remember fixing this by making all variables pass through the root of the flash movie into text boxes before moving them within the movie (using eval)

one of my database example at:
http://www.toshiba.co.uk/eid
look at the RESELLER LOCATOR link it loads all data from a database so never needs updating and works on all platforms including macs and unix

PS how long does one remain a 'New Member' for?

[Edited by mnm on 04-23-2001 at 06:58 AM]