 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ASP / Database Access / July 2008ASP Login Database to Online Form Registration
Hey. I'm just starting to learn ASP and I'm trying to figure out to do things. What I want to do is have a Login page as well as a Create Account page (both is ASP). The user would create an account (username and password) which would be put into an Access databse. Then they can Login, and would take them to a Registration Form page, if their user info is validated against the database. Once they've gotten to the form page, they'll need to fill out the form, submit it, and that info would be put into the database as well (same database, just different table). What I figured I could do is have the Username as the primary key for both tables so that if a user logs back in to make any changes, it could pull the info from the table and fill in the fields they previously filled in so when they submit it again, it would overwrite what they previously put it. Now here's a tricky part. This is a student registration, so lets say a parent wants to register several children each at different schools, and use the same Username/Password, I was thinking of just having it put a seperate entry into the 'registration' table with the same Username. That way when we go to look these up when the parent comes in to sign paperwork, we can pull up the info by the Username, since there are probably going to be people with same name. Any help would be appreciated. Thanks. ~ Jason Sounds fine to me. Until you mentioned the idea of many children for one username, I was ready to ask why you even bothered with two separate tables. No reason you couldn't use one table that is partly filled in by one page and partly by another. That *STILL* might be the right idea for data that is common for all children. Example: parent's phone number, address, parent's age, etc. So you *ONLY* put in the child-specific stuff to the CHILDREN table. One minor thing: Commonly, we use an autonumber field as the primary key in the PARENTS table. And then use integer field as foreign key in the CHILDREN table. Reason: If somebody wants to change his/her username, you don't have to change any records in the CHILDREN table. This is called "NORMALIZATION". But for a small DB, it's not a big issue. Username works fine. [My own preference is to use EMAIL as the username and then the autonumber field as primary key. Since EMAIL is always unique, you won't have the problem of two people trying to use the same username. But, again, this is implementation detail, not affecting the concepts.] Did that help or make things worse? > Hey. I'm just starting to learn ASP and I'm trying to figure out to do > things. What I want to do is have a Login page as well as a Create [quoted text clipped - 21 lines] > Any help would be appreciated. Thanks. > ~ Jason **************** If somebody wants to change his/her username, you don't have to change any records in the CHILDREN table. This is called "NORMALIZATION". **************** Actually it's not normalization, it's referential integrity, which really has not much to do with normalization. Although I wouldn't use the username as the key either, a cascading update would solve the problem you describe. Bob Lehmann > Sounds fine to me. > [quoted text clipped - 47 lines] > > Any help would be appreciated. Thanks. > > ~ Jason > **************** > If somebody wants to change his/her username, you don't have [quoted text clipped - 69 lines] > > - Show quoted text - Thanks. Makes sense. Are there any good ASP scripts out there working with 'creating an account' and 'login' pages? ~ Jason On Jul 1, 10:16 pm, "Bob Lehmann" <nos...@dontbotherme.zzz> wrote: > **************** > If somebody wants to change his/her username, you don't have [quoted text clipped - 77 lines] > > - Show quoted text - Thanks. Makes sense. Are there any good ASP scripts out there working with 'creating an account' and 'login' pages? ~ Jason Loads probably. Try www.aspfree.com for starters. -- Mike Brind Microsoft MVP - ASP/ASP.NET > On Jul 1, 10:16 pm, "Bob Lehmann" <nos...@dontbotherme.zzz> wrote: > [quoted text clipped - 94 lines] > > - Show quoted text - Thanks Mike > On Jul 1, 10:16 pm, "Bob Lehmann" <nos...@dontbotherme.zzz> wrote: > [quoted text clipped - 94 lines] > > - Show quoted text - Thanks everyone. I've got it working. My next dilemma is to create page for users to be able to edit information (students) they submitted based on their login info. So a person would login, which would take them to a page where they could click to "Sumit a new student" as well as list the students' name they've already register/ submitted, which they can click to edit that entry/student info. When they click on the student name, it would take them to the form with all of the information in it pulled from the database (Access). P.S. - Using ASP Thanks in advance. ~ Jason |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.