Retrieving username in ASP

[Mike1500]

Hello All,

I looked everywhere for the answer to my question but with no success. The
question is how can I retrieve the username for the user who submitt a form
using ASP in a intranet environment? Please, Please, Please help. Thanks.

Database: SQL Server
Windows 2000 platform

[twocans]

Hi yea Mike,
this should help
[url]http://www.webthang.co.uk/tuts/tuts_dmx/gk_users/gk_users_4.asp[/url]

what he give here is an example of a user logging in and then beeen welcomed
as in you login and then get a Hello Mike , by having a look at this
tutorial you should then be able to do what you want to do.

regards

twocans



"Mike1500" <webforumsuser@macromedia.com> wrote in message
news:d1av5f$p6q$1@forums.macromedia.com...

> Hello All,
>
> I looked everywhere for the answer to my question but with no success. The
> question is how can I retrieve the username for the user who submitt a
> form
> using ASP in a intranet environment? Please, Please, Please help. Thanks.
>
> Database: SQL Server
> Windows 2000 platform
>

[Julian Roberts]

Have a look at the ServerVariable collection. I think it's LOGON_USER. Or
maybe look at [url]www.aspuser.com[/url]

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[Mike1500]

Thanks folks for the response, but it not working. Below is the code I'm using
to compare the current username with the database username. Does anyone know
how to accomplish this task?? Please help.

SELECT *
FROM dbo.Net_User
WHERE UserName = 'MM_Username'

[Les Matthews]

You used DW's standard User Authentication server behaviors for login?
If so, the SB does create MM_Username - but it's a session var. Try
Session("MM_Username").


"Mike1500" <webforumsuser@macromedia.com> wrote in message
news:d1d3fc$8lp$1@forums.macromedia.com...

> Thanks folks for the response, but it not working. Below is the code I'm
> using
> to compare the current username with the database username. Does anyone
> know
> how to accomplish this task?? Please help.
>
> SELECT *
> FROM dbo.Net_User
> WHERE UserName = 'MM_Username'
>

[RobGT]

You will need to use a parameter in the SQL and specify a run-time value for
that parameter.
In Simple recordset builder:

1. Name your recordset
2. Select your connection
3. Select the table that you are selecting the username from
4. Select the columns (or select * - inefficient but it works)
5. Select the column to filter on
6. Select the comparison operator (=)
7. Select Session Variable
8. Enter Session("MM_Username")

That should do it.
HTH
Rob
[url]http://robgt.com[/url]