Does anybody know how I can retrieve the hole name for my users from my database upon successful login?

I would really like to say Welcome... when my visitors successfully log in.
I allready have a field in the database called "name" after the username and password columns.

I use DWMX and Access..

Appreciate all help. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Sarre

Hi Sarre

If you are using the Login User server behaviour then the following should give you the results you're after.

Find the line line referring to the SQL statement, something like:

MM_rsUser.Source = "SELECT username, userpassword"

and change it to:

MM_rsUser.Source = "SELECT username, userpassword, userwholename"

The next step is to create a Session variable and insert the recordset value MM_rsUser("userwholename" to the Session variable.

Find the following comment, again in the Login User behaviour code:

' username and password match - this is a valid user

beneath the comment add:

Session("UserWholeName" = MM_rsUser("userwholename"

The Session variable now contains the recordset value for the userwholename, which you can display on the page and any other page by:

Response.Write(Session("UserWholeName")

I think that's about all.

Digga

Sharing Knowledge Saves Valuable Time!!!

Hi Digga!

As usual you came up with a solution.
Your tip worked like a charm..

Thanx a million! <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Sarre

You're welcome!

Digga

Sharing Knowledge Saves Valuable Time!!!