Re: ASP Login Database to Online Form Registration
Re: ASP Login Database to Online Form Registration
Source: http://www.tech−archive.net/Archive/Internet−Server/microsoft.public.inetserver.asp.db/2008−07/msg00012.html
• From: Jason
• Date: Tue, 22 Jul 2008 09:38:16 −0700 (PDT) On Jul 2, 2:40 pm, "Mike Brind [MVP]" wrote: "Jason" wrote in message news:a0325a9c−5e5e−4bd4−b52e−6de0b1a9bbdf@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx On Jul 1, 10:16 pm, "Bob Lehmann" wrote:
**************** 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
"Old Pedant" wrote in message
Re: ASP Login Database to Online Form Registration
1
Re: ASP Login Database to Online Form Registration news:16348178−40BE−4B69−A38B−48046AED034C@xxxxxxxxxxxxxxxx
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
Re: ASP Login Database to Online Form Registration
2
Re: ASP Login Database to Online Form Registration "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?
"Jason" wrote:
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 Re: ASP Login Database to Online Form Registration 3
Re: ASP Login Database to Online Form Registration 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− Hide quoted text −
− 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. Trywww.aspfree.comfor starters. −− Mike Brind Microsoft MVP − ASP/ASP.NET− Hide quoted text − − Show quoted text −
Re: ASP Login Database to Online Form Registration
4
Re: ASP Login Database to Online Form Registration 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 .
Re: ASP Login Database to Online Form Registration
5