Redirection to a unique page based on user/pass in ASP

Posted on 2004-04-27
Last Modified: 2010-04-06
I have a logon set up, but I'm looking to redirect the users to a page that will have info specifically for them.  I have considered storring the page in the database and then getting it once the pass/user are checked.  Also, I'm trying to figure out how to protect these pages.  I've thought of using the session variable to restrict access, but I could use some coding examples on this.  I'm a newbie with ASP, so as much step through as you can give would help.  I place a high value on this and I'm not in the same time crunch I was, but time is somewhat of a factor.
Question by:themikecooke
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
LVL 10

Assisted Solution

m8rix earned 100 total points
ID: 10935925
First of all, read the tutorial on this page, it is very straight forward and easy to follow there.

In addition to that you can set a cookie:


and query your database with this information.

Accepted Solution

pkaleda earned 400 total points
ID: 10938837
Another great resource for ASP and all other web dev subjects is  You can start by reading ASP section.  they have an area for Sessions as well.

What I would do is store the information you want to show teh user in a database.  Tie it to a user id or username.  when they login, you can do this?

session("Username") = rs("Username") ' rs is teh recordset from a database or you can use any other way to set it.
session("UserID") = rs("UserID")

Then you create a single page that pulls the information from a database and displays it based on the user.

Userid = Session("UserID")

conn=Connect String
sql = "Select * from userinfotable where userid = '"&userid&"'"
set rs = conn.execute(sql)

If not rs.eof then
on error resume next
while not rs.eof
response.write("here is your info "&rs("column1")&"<br />")
end if

Now you have one page that is used by all users, but the info displayed is taylored based on thier userid or username.


Author Comment

ID: 10943911
   I'm liking your solution.  Basically I have a ppt that I want the user to have access to and to be able to see.  Each presentation is tailored to the user.  I'm going to play with this solution a for another 12 hours before closing the question.  Thanks for the help!
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Expert Comment

ID: 10944289
Cool.  Glad I can help.  I think this is a great simple solution.

Expert Comment

ID: 10944298
You can also when they go to the page, have it auto redirect them to teh PPT so it opens without them having to click anything.
LVL 10

Expert Comment

ID: 10944545
> First of all, read the tutorial on this page, it is very straight
> forward and easy to follow there.

> In addition to that you can set a cookie:
> Session("UserAccount")=Username
> and query your database with this information.

Thanks to PK for following on from my post and demonstrating on how to query your database with the user information I specified.

all you have to do now is store the ppt file name in a database field so when the user's log in has been authenticated you can then retrieve the personalised ppt file.

The best thing about this is that you can display any number of ppt files for each unique user.

Glad we could help.


Expert Comment

ID: 10948860
Thank you for the A.  Glad we could help.

Author Comment

ID: 10956150
Can you give me some coding for how I might display the ppt files.  I would like to have them as pps files so that they simply run.  But, I can pull the location from the database, but how do I open the pps in a new window.  Any suggestions would be greatly appreciated.


Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Share post from Facebook Tab Application 6 47
Web Application Architecture 6 80
Import data into excel from web page 10 110
Create animated movies for web page 18 119
What is Node.js? Node.js is a server side scripting language much like PHP or ASP but is used to implement the complete package of HTTP webserver and application framework. The difference is that Node.js’s execution engine is asynchronous and event…
I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to count occurrences of each item in an array.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question