Solved

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

Posted on 2004-04-27
8
210 Views
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.
0
Comment
Question by:themikecooke
  • 4
  • 2
  • 2
8 Comments
 
LVL 10

Assisted Solution

by:m8rix
m8rix earned 100 total points
ID: 10935925
First of all, read the tutorial on this page http://www.codefixer.com/tutorials/session_cookies.asp, 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.
0
 
LVL 6

Accepted Solution

by:
pkaleda earned 400 total points
ID: 10938837
Another great resource for ASP and all other web dev subjects is http://www.w3schools.com/.  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 />")
rs.movenext()
wend
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.

PK
 
0
 

Author Comment

by:themikecooke
ID: 10943911
PK
   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!
0
Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
LVL 6

Expert Comment

by:pkaleda
ID: 10944289
Cool.  Glad I can help.  I think this is a great simple solution.
0
 
LVL 6

Expert Comment

by:pkaleda
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.
0
 
LVL 10

Expert Comment

by:m8rix
ID: 10944545
> First of all, read the tutorial on this page http://www.codefixer.com/tutorials/session_cookies.asp, 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.

m8rix
0
 
LVL 6

Expert Comment

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

Author Comment

by:themikecooke
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.

Mike
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Shoutout to Emily Plummer (http://www.experts-exchange.com/members/eplummer26.html) for giving me this article! She did most of it, I just finished it up and posted it for her :)    Introduction In a previous article (http://www.experts-exchang…
SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to count occurrences of each item in an array.

803 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