how do i set up a login system

[go piss up a rope]

i am currently creating a web site for a school project and i require the
user to register and login. I have the registration set up i just need to
know how to refrence the username and password to see if it matches any thing
in the database

 

[MD Websunlimited]

Hi Go Piss Up A Rope,

Nice name you have for yourself. It may provide clues about your character and intelligence ;>)

Assuming that you're not skilled in ASP programming, I've also assumed that you created the registration utilizing the DIW (Database
Interface Wizard) in FP.

To check the registration you have to use ASP code to read the database with a SQL Select statement and then compare the records
password with the password provide by the visitor.

oRS.Open "Select * from Users where User = """ & request.form("User") & """;"
if Not oRS.EOF then
if oRS.Fields("PassWord") = request.form("PassWord") then
'
' Set a session var that is check by each page
'
session("LoggedIn") = "yes"
request.redirect "firstprotectedpage.asp"
end if
else
Msg = "UserID or Password is not correct please try again."
end if


The above is the core code but would also require the page setup, etc.

HTH,

 

[colby]

allright since i dont know asp programing can i use vb programing to access
the database?

and on another note im only 14

 

[Bob Lehmann]

The sample you were give was VB.

Bob Lehmann

allright since i dont know asp programing can i use vb programing to access
the database?

and on another note im only 14

 

[Stephen Green]

There is a good login program available here:

http://www.outfront.net/spooky/login.htm

The free version is barebones, but works well.

Take care.

Stephen

Hi Go Piss Up A Rope,

Nice name you have for yourself. It may provide clues about your character and intelligence ;>)

Assuming that you're not skilled in ASP programming, I've also assumed

that you created the registration utilizing the DIW (Database

Interface Wizard) in FP.

To check the registration you have to use ASP code to read the database

with a SQL Select statement and then compare the records