Forums

This topic is locked

How to do login page with "Welcome user"

Posted 04 Nov 2005 12:37:55
1
has voted
04 Nov 2005 12:37:55 Malcolm X posted:
Hi there, I just wanted to know how to create code or is there an option in Dreamweaver / ASP that when you login to a page the welcome page comes up with the users name up the top.

Eg: Welcome to our website JIM.

We have created a login page using Dreamweaver and Microsoft Access as the database with login names and passwords. Also using ASP.

Any helpw would be greatly appreciated.

Thanks.

Malcolm .

Replies

Replied 04 Nov 2005 15:44:42
04 Nov 2005 15:44:42 Michael Behan replied:
you need a recorset along these lines (called getUser for example)

select * from users where username = 'userParam'

then define userParam like this (name | default | runtime value)
userParam | 0 | Session("MM_Username"

then supposint the users table has a field called realName you would have

<pre id=code><font face=courier size=2 id=code>Welcome back &lt;%=getUser.Fields.Item("realName".Value%&gt;.</font id=code></pre id=code>

Edited by - mbisme on 04 Nov 2005 15:45:18
Replied 04 Nov 2005 16:35:37
04 Nov 2005 16:35:37 Wayne Hultum replied:
you could use a session variable

www.w3schools.com/asp/asp_sessions.asp

Reply to this topic