Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 14th, 2006, 03:31 AM
Registered User
 
Join Date: Oct 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Need an ASP script for Member reg. & Logon

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


 
Old October 16th, 2006, 08:01 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

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





Similar Threads
Thread Thread Starter Forum Replies Last Post
reg conn from asp.net to sql veda SQL Server ASP 5 May 22nd, 2008 06:10 AM
Ch 11 creating a user reg script ed123 BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 0 September 28th, 2007 11:36 AM
Reg: displaying datase in xml format asp.net 2.0 sadiashoiab ADO.NET 0 April 19th, 2007 03:17 PM
logon.asp and validate .asp problems p2ptolu Classic ASP Basics 1 February 17th, 2005 12:33 AM
ASP logon page Cinderella Classic ASP Basics 5 February 14th, 2005 02:37 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.