login and asp

[Marie Goodwyn]

 

I need to add a login to a flash movie that will be linked to an Access database where it will check the user name and password.  I saw the example for mySQL, but what would it be in ASP and Access?

[Flash-db]

I don't know of the exact code offhand but it would be something like this:

In the flash movie - have two input boxes for a UserName and Password.  Then in that same movie clip have a LoadVariables command - something like:

on (release) {
loadvariablesNum("YourASPscript.asp", 0, "POST");
}

This will post the Username and Password the person entered to that script.  Then you'll have to compare those two values to the corresponding UserName and Password found in the database.

[ asp code ] (I'm not sure what the exact code in ASP would be to do that.

Then if you get a match - IE the UserName and password that the person enters match the UserName and Password in the database you'll want to print out something like this:

document.write "Status=Success - You have successfully logged in&Enter=Yes";

Place that in an IF/Else statement - so if the UserName and Password where not matched print out something like this:

document.write "Status=Failure- we where not able to log you in.&Enter=No";

Have something in your Flash movie that checks the returned value of "Enter" - If enter is equal to "Yes" then they can proceed to the password protected area's of the site.  If Enter is equal to "No" - then they must try loggin in again.