First, my Server supports ASP and not PHP.

I am developing a website that has 2 sections, a Viewers section and a Members section.

Visitors to this site are taken to the Viewers section and will be free to view all of the general content of the site.

The Members section will contain (ASP) interactive applications and folks that wish to enter the “Members Section” will have to sign in with a User Name & Password to participate in the applications activities.

I am looking for (an ASP) Script, similar to the type of script that Forums use to register their members.

However, all that I want this script to do is to request the prospective member to create a User Name & Password and then complete their member registration by including a valid email address.

Beyond that, I would also like this script to list their membership information (UN, PW and email address) into a database so that I can create a form for them to use to sign into the membership area.

Many folks have given me links to places where I can view a variety of possible appropriate scripts however, although I have found many “Form Validation” scripts available, I have found that All of these contain many other things that I do not need this script to do and I do not know how to alter them to do what I need this script to do.

Can anyone suggest aa ASP script that will simply create a member registration using just a UN, PW and email address and enter that information into a database?

Thanks,
Charles

I am not trying to sound condescending here but a Form Validation script IS what you want. (I am going to assume that you have basic understanding of ASP)

From what you have said, you need a form with 3 text boxes (4 for a confirm password box) on it (from here you could use a javascript validator and prevent the page from posting back to the server for validation, but the user can turn js off)

The username and 2 password fields are trivial because the username and password have to be something other then "" and the 2 passwords must match. (You need to determine whether or not you are making passwords case sensitive or not) In the case that passwords are not case sensitive you would do

Dim pw1, pw2
pw1 = Request.Form("pw1").toLower()
pw2 = Request.Form("pw2").toLower()

if pw1 <> pw2 then 'do something

The email address validation is a bit tricky (in .NET we have the benifit of a regex engine so it is a trivial matter to validate an email address) so i suggest you check out this link as far as email address validation goes:

http://www.4guysfromrolla.com/webtec...ateemail.shtml

Lastly, to make sure that the username the user has picked isnt in use you can do a couple of things:

SELECT [something] FROM [table] WHERE username=' & Request.Form("username") &"'"
The above example you check to see if something is return to your record set...i dont like that way of doing things, I would probably do:

SELECT count([field]) FROM [table] where username=' & Request.Form("username") &"'"
If this returns 0 the username doesn't exisit else it does.

hth

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature