Re: ASP Login Database to Online Form Registration

On Jul 1, 10:16 pm, "Bob Lehmann" <nos...@xxxxxxxxxxxxxxxx> 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" <OldPed...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message

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
"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 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
.

Relevant Pages

  • Re: Login issues
    ... Depending on the computer or username, ... There is not way to enter to the database using ... If I enter as usual from my computer, the FM server automatically ... Perhaps someone changed your script, or the user name on your computer, or the default account in File Options. ...
    (comp.databases.filemaker)
  • Cant log in using .NET Provider (invalid username/password)
    ... a database with a table. ... with an account i created with no password. ... I've double checked the username & password and they are correct. ...
    (comp.databases.ingres)
  • Re: Password Problem - PLEASE HELP!
    ... Highlight admin user account, ... Now when I close the database and reopen it, i am prompted for a user ... keeping "admin" as the username and the password is 123456. ...
    (comp.databases.filemaker)
  • Re: Problem on changing a user account
    ... Renaming an account doesnt change the sid if you look at your account ... I needed to work on a database system of a ... which necessitates the username that you log on windows to be ... >the same as the database username. ...
    (alt.os.windows-xp)
  • Re: Password Problem - PLEASE HELP!
    ... When logging in to the admin account you should use Admin as username and ... Then you should create for every different level of acces a new account. ... Now when I close the database and reopen it, i am prompted for a user ... When I type in the username and password I receive ...
    (comp.databases.filemaker)
Loading