2. ASPRunnerPro General questions
  3. After logged IDUser ?
This topic is locked

After logged IDUser ?

 		5/15/2009 14:49:59
ASPRunnerPro General questions
R
 Ricardo Web author

Hi,
How can get IDUser after logged ?
but i don´t have nothing variable which identifies the IDUSER.
tanks
S
 		stalbone 5/18/2009

Hi,

How can get IDUser after logged ?
but i don´t have nothing variable which identifies the IDUSER.
tanks


USERID = UCase(Session("UserID"))
Ciao

Stefano
R
 		Ricardo Web author 5/18/2009

Good , but USERID = UCase(Session("UserID")) , shows login (String) , i need primary key(ID) of the user logged, exists session for this?
I do NOT want set "select ID from table where login = Session("UserID")", have other solution?
J
 		Jane 5/19/2009

Hi,
you can select IDUser in theAfterSuccessfulLogin event on the Events tab and save it in the session variable manually.
R
 		Ricardo Web author 5/20/2009

OK, but then in the AfterSuccessfulLogin event on the Events , i have to do :
str = "Select IDUsuarios from Usuarios where login = '"&Session("UserID")&"' "

set rs = dbconnection.execute(str)
Session("IDUser") = rs("idUsuarios")
doesn´t have other solution, for get ID of the user logged?
thanks.
J
 		Jane 5/21/2009

Unfortunately no.