tom_s
|
Posted: 04/04/2001, 7:34 PM |
|
When using security, is the Login_User_ID available as a session variable to
a project?
I would like to find all records 'where recordUserID = Login_User_ID' , but
do not know the name of this variable.
Thanks in advance,
Tom S
|
|
|
Hellen
|
Posted: 04/05/2001, 1:04 AM |
|
1) If you are using ASP , than after successfull login you can already
access this value through session("UserID")
2) In php use get_session("UserID")
3) In jsp use session.getAttribute("UserID")
4) In Perl use GetSessionVar("UserID")
if you want to use session variable in SQL query write query SQL Tab
'Using SQL Stirng' and in 'Where' textbox add the clause with Session:
1. for Perl
and c.recordUserID = " . GetSessionVar("UserID") . "
2. for ASP
and c.recordUserID = " & Session("UserID") & "
3. for JSP
and c.recordUserID = " + session.getAttribute("UserID") + "
4. for PHP
and c.recordUserID = " . get_session("UserID") . "
"tom_s" <tsoko@gte.net> wrote in message
news:9aglje$pr5$1@mail.tankhill.com...
> When using security, is the Login_User_ID available as a session variable
to
> a project?
>
> I would like to find all records 'where recordUserID = Login_User_ID' ,
but
> do not know the name of this variable.
>
> Thanks in advance,
> Tom S
>
>
|
|
|
tom_s
|
Posted: 04/05/2001, 5:10 PM |
|
Thanks Hellen,
It worked in ASP 2.0 using recordUserID = " & Session("UserID") & " without
the leading c.
Thanks again for the speedy reply
"Hellen" <support@codecharge.com>wrote in message
news:9ah8te$t14$1@mail.tankhill.com...
>
> 1) If you are using ASP , than after successfull login you can already
> access this value through session("UserID")
> 2) In php use get_session("UserID")
> 3) In jsp use session.getAttribute("UserID")
> 4) In Perl use GetSessionVar("UserID")
> if you want to use session variable in SQL query write query SQL Tab
> 'Using SQL Stirng' and in 'Where' textbox add the clause with Session:
> 1. for Perl
> and c.recordUserID = " . GetSessionVar("UserID") . "
> 2. for ASP
> and c.recordUserID = " & Session("UserID") & "
> 3. for JSP
> and c.recordUserID = " + session.getAttribute("UserID") + "
> 4. for PHP
> and c.recordUserID = " . get_session("UserID") . "
>
> "tom_s" <tsoko@gte.net> wrote in message
>news:9aglje$pr5$1@mail.tankhill.com...
> > When using security, is the Login_User_ID available as a session
variable
> to
> > a project?
> >
> > I would like to find all records 'where recordUserID = Login_User_ID' ,
> but
> > do not know the name of this variable.
> >
> > Thanks in advance,
> > Tom S
> >
> >
>
>
|
|
|
|