Hello all.
Made it 3 yrs without having to make a post. But now I am running out of time and patience on this problem. Here we go...
Trying to capture information for the logged in user and store those values in session variables. I have set up the post login �process� page and set up the page redirect in security. The code I am currently using on the process page is derived from a response posted by Kieth Hubert on 12-24-2011. Here's the sheet music:
<%a5
dim tbl as p
session.CurrentUserName = "wilma" 'a5ws_getcurrentuser()
'Hard coded user name for testing purposes
'Begin test code
'test code modified from the message board > "How to reteive data after login for that particular user id?"
tbl=table.open("org_empl")
query.filter=("user_name=var->Sesssion.CurrentUserName")
tbl.query_create()
session.org_id=alltrim(tbl.org_id)
session.first_name=alltrim(tbl.org_empl_first)
session.last_name=alltrim(tbl.org_empl_last)
tbl.query_detach()
tbl.close()
'End test code
response.redirect("HomePage.a5w")
%>
When I run this it throws an error message that says:
�Script: TEMPLATE line:9
tbl.query_create()
Cannot use function in this context�
I have tried many other things trying to solve my issue with no success. Ideas??
Thanks in advance!
Rob
Made it 3 yrs without having to make a post. But now I am running out of time and patience on this problem. Here we go...
Trying to capture information for the logged in user and store those values in session variables. I have set up the post login �process� page and set up the page redirect in security. The code I am currently using on the process page is derived from a response posted by Kieth Hubert on 12-24-2011. Here's the sheet music:
<%a5
dim tbl as p
session.CurrentUserName = "wilma" 'a5ws_getcurrentuser()
'Hard coded user name for testing purposes
'Begin test code
'test code modified from the message board > "How to reteive data after login for that particular user id?"
tbl=table.open("org_empl")
query.filter=("user_name=var->Sesssion.CurrentUserName")
tbl.query_create()
session.org_id=alltrim(tbl.org_id)
session.first_name=alltrim(tbl.org_empl_first)
session.last_name=alltrim(tbl.org_empl_last)
tbl.query_detach()
tbl.close()
'End test code
response.redirect("HomePage.a5w")
%>
When I run this it throws an error message that says:
�Script: TEMPLATE line:9
tbl.query_create()
Cannot use function in this context�
I have tried many other things trying to solve my issue with no success. Ideas??
Thanks in advance!
Rob
Comment