flash data integration: How far have you gotten?

--
Lon Hosford
www.lonhosford.com
May many happy bits flow your way!
[quoted text, click to view]
Hi, I'm trying to create a quizwhere the user selects a radio button and the
answer needs to be checked in an MS Access 2003 table for correctness. Can
anyone help me connect my application with the DB and get it to work
properly?
Thanks, Robert

Hi, I'm trying to create a quizwhere the user selects a radio button and the
answer needs to be checked in an MS Access 2003 table for correctness. Can
anyone help me connect my application with the DB and get it to work properly?
Thanks, Robert

Well here is an overview.

You choose either LoadVars or XML to handle the data communications to a
serverside script likely in ASP since you want to use MSAccess.

LoadVars are for data formatted as URL Vars data format and XML as XML data
format.

Examples in the Flash help are super templates for using these:

LoadVars: http://livedocs.macromedia.com/flash/8/main/00002336.html
XML: http://livedocs.macromedia.com/flash/8/main/00002879.html

On the server side, you select either VBScript or JScript as the scripting
language and you use ASP to receive and send data to Flash. In ASP for
LoadVars it is the Response.write to send data to Flash and
Request("NameOfVar") to read data received from Flash. In ASP for XML you
use Server.CreateObject("Microsoft.XMLDOM") to receive and parse XML data
sent from Flash and Response.write to send XML to Flash.

Then you would likely use the ADO library to communicate with the MSAccess
database. That you use the ASP Server.createObject("ADODB.Connection") code
to get access to the library.




--
Lon Hosford
www.lonhosford.com
May many happy bits flow your way!
[quoted text, click to view]
Just starting. I couldn't find any related documentation.

I just bought a book called Flash 8@Work by Phillip Kerman. He has a whole
series of chapters devoted to online quizes, how to present them, evaluate
them, and store the results. I just skimmed briefly but the projects look
well-designed and very useful. Hope this helps. -jheske