Unanswered: Retrieving a data field from a database
Hi guys, right, im using asp connected to access db. When im on my login page in my browser and i click submit i would like on the next page for it to say Welcome 'Customer Name', how would i go about doing this? And where abouts are the scripts implemented? Any help would be great im new to this.
You could also store the user's name in a Session variable, though this is not recommended by some developers because of the tremendous traffic some sites get (the Session variable won't be deleted from the system until the Session times out which could lead to a large drop in system resources). My site gets limited traffic, so I'm not worried.
I store the user's login name and a few other details in Session variables (and a Cookie too). Then I don't have to check the DB every time they open a new page - I can either check the Session variables or the cookie.