473,231 Members | 1,902 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,231 software developers and data experts.

ASP Login / Database Help.

I am needing some help with a few asp pages and a login script.

Let me start by describing my project.

I am trying to connect to a database and verify a users login and password,
then based on that login information display 3 pages based on their login.

On the home page if they are NOT logged in, I need it to display the login
box, if they ARE logged in I want it to display Welcome Customer Name from a
database called vcust.dbf which contains both the username and password
fields.

The two other pages will be based on the username (which is actually my
customers customer number ... example '100001'). I am needing to display
the customers account informaiton on one page from the vcust.dbf and their
rental history on another page from records.dbf.

To get a better idea of what I need, you can visit my site at
http://www.mcmillans.com and view the home page, the My Account page and the
Rental History page.

I am on a non-existant budget and am hoping to find someone who has some
extra time and willing to donate an hour or two to help me with this. If so
you are welcome to use my site on your resume or references.

Thanks!

Chris

PS. Please email me if you have questions or can help me out at
ch***@mcmillans.com
Jul 19 '05 #1
2 1931
Use session variables. I'm guessing you have a userID or loginID table in
your database. when they log in it should verify the form fields with the
database table login id and password. Set a session variable to be their ID
(i.e. customer #, assuming it's unique):
for example, session(cusID) = tableName("customerNumberFieldName")
So on the home page you would have something like:
If session(cusID) <> "" Then
' write out page here with account info from vCust.dbf, rental history, etc
else response.write "Enter Login ID: <input type='text' name='loginID'>
Password: <input type='text' name='password'>"
End If

Hope this helps!

"harris" <ha****@computekdirect.com> wrote in message
news:Y6*******************@bignews5.bellsouth.net. ..
I am needing some help with a few asp pages and a login script.

Let me start by describing my project.

I am trying to connect to a database and verify a users login and password, then based on that login information display 3 pages based on their login.

On the home page if they are NOT logged in, I need it to display the login
box, if they ARE logged in I want it to display Welcome Customer Name from a database called vcust.dbf which contains both the username and password
fields.

The two other pages will be based on the username (which is actually my
customers customer number ... example '100001'). I am needing to display
the customers account informaiton on one page from the vcust.dbf and their
rental history on another page from records.dbf.

To get a better idea of what I need, you can visit my site at
http://www.mcmillans.com and view the home page, the My Account page and the Rental History page.

I am on a non-existant budget and am hoping to find someone who has some
extra time and willing to donate an hour or two to help me with this. If so you are welcome to use my site on your resume or references.

Thanks!

Chris

PS. Please email me if you have questions or can help me out at
ch***@mcmillans.com

Jul 19 '05 #2
Robin wrote:
Use session variables. I'm guessing you have a userID or loginID table in
your database. when they log in it should verify the form fields with the
database table login id and password. Set a session variable to be their ID
(i.e. customer #, assuming it's unique):
for example, session(cusID) = tableName("customerNumberFieldName")
So on the home page you would have something like:
If session(cusID) <> "" Then
' write out page here with account info from vCust.dbf, rental history, etc
else response.write "Enter Login ID: <input type='text' name='loginID'>
Password: <input type='text' name='password'>"
End If


Personally I'd suggest using cookies. Session variables hog server
memory and need to be timed out to stop the server running out of memory.

I often get frustrated when I have several things on the go and a site
times my login out for inactivity. If you use cookies to store the
userid and password and check this on each page, the user can leave a
browser inactive for hours (or days) and still not be timed out.

--

ca******************************@hotmail.com

(remove Tony Blair from office to contact me)
Jul 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Wayne Smith | last post by:
Applies to: Microsoft FrontPage 2000, Microsoft Access 2000, IIS 5.0 Operating System: Microsoft Windows 2000 Professional I am trying to protect a portion of a web site by allowing users to...
12
by: Michael | last post by:
Please Help me. I've got a .Net 2003 program that attaches to a SQL Server machine and I'm getting the above error when a user tries to log in. The SQL server is setup to use Windows Auth. and I...
1
by: Friends | last post by:
Hi I need to set security for row level but not based on Database user's login. It should be based on the user table login. For the particular user I need to allow only the particular records to...
10
by: Pete | last post by:
I have used Visual Studio 2005 to create a website. I set up standard login page using standard procedures. Nothing fancy or out of the ordinary, just standard procedures described in any "Login...
1
by: xcelmind | last post by:
Hello Dev. Guru, I want to at this time introduce myself. I am Stanley Ojadovwa by name. Iím a freelance and a newbie in web application development. Iím currently using ASP as my application...
9
by: Ben | last post by:
Hello, I'll bet this has been asked a million times but I can't seem to find a thread that gives the clear example I need. This PC has MySQL and IIS configured and running. The MySQL database is...
13
JodiPhillips
by: JodiPhillips | last post by:
G'day, I have a silly and simple problem that I need some guidance with. Due to the way our network is set up, I am unable to use the group permissions for Access and have had to implement log...
3
by: satishknight | last post by:
Hi, Can some one tell me how to change the validation sequence for the code pasted below, actually what I want it when any one enters the wrong login information (already registered users) then it...
4
by: Brett | last post by:
I have an ASP.NET 2.0 application that uses Forms Authentication. The startup page contains just a login control, and the site works well on an IIS 6 web server. I am now setting the site up on...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, youíll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.