This topic is locked

Pass login variable

8/11/2007 21:12:26
ASPRunnerPro General questions
K
kwilsokl author

I am using ASP runner 4.1

I am wondering how to grab the ID of the user who is logged in and then pass the login information to a query.
I have an access query that pulls up data based on the parameter typed in for the user. How can I have ASP Runner grab the logged in user and use that in the parameter
Thank you for any help

Sergey Kornilov admin 8/12/2007

It sounds like you need to use Advanced Security mode Users can see and edit their own data only.

In this case UserID is added to the SQL query automatically.