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?
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 16:35.
hope this help
See clear as mud
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 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.