Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007

    Question Unanswered: ASP Client Log In Question

    Hi All,

    I hope someone can help with this issue I'm having. I've found much useful information on this site before so I'm crossing my fingers that I can this time.

    I want to creat a logon page, on my website, where when a client clicks "logon" they can enter their username and password, and be taken to their specific page. I want each protected page to be assigned to it's own user. For instance, let's say Client1 wants to log in to thier page - they enter their username and password and they are taken to Client1's Page. Then if Client2 wants to log on, they enter username and password and are taken to their unique Client2 page.

    Ideally, each client will have their own username and password set to take them to their own page.

    Can anyone provide some code or insight on what needs to be done here?

    Thanks much!

  2. #2
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 10
    all you have to do is in the protect table ad the ClientID to that table then when the user logs in you just filter the protect table by the clientID.

    what i do is after the user has login create a session cookie.

    session("ClientID") = rs("ClientID")

    then each time the user go to a page

    I write the SQL

    SQL = ""
    SQL = SQL & "Select tablename.*"
    SQL = SQL & " From tablename"
    SQL = SQL & " Where ClientID=" & Session("ClientID") & " And the rest of the where bit"
    Last edited by myle; 04-21-09 at 17:35.
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts