Variable name

Description

SESSION("UserID")

Logged user ID

SESSION("GroupID")

GroupID that user belongs to. Populated if User Group Security turned on.

SESSION("UserRights")("<table name>")

User permissions for selected table (used for dynamic permissions).

To get the value of this variable use special function GetUserPermissions("<table name>") that returns set of permissions for current user in the AEDSPIM format, where

A - add, E - edit, D - delete, S - search/list, P - print/export, I - import, M -admin group.

Dim permissions

permissions = GetUserPermissions("Cars")

If you need to assign the value to the variable, use the variable directly.

Session("UserRights")("Cars") = "AEDSPI"

SESSION("language")

Current selected language i.e. "English" or "Spanish".

To get the value of this variable use special function mlang_getcurrentlang() that returns current selected language.

If you need to assign the value to the variable, use the variable directly.

Session("language")="English"

SESSION("MyURL")

If user is trying to access one of password-protected pages directly i.e. pagename_edit.asp?editid1=3 this page address is saved in SESSION("MyURL") variable and user is redirected to the login page.

After successful login user will be redirected to that page.

SESSION("AccessLevel")

ACCESS_LEVEL_GUEST - guest user

ACCESS_LEVEL_USER - regular user

ACCESS_LEVEL_ADMINGROUP - user belongs to the admin group

ACCESS_LEVEL_ADMIN - obsolete

SESSION("OwnerID")

OwnerID value from the login table. Obsolete

SESSION("_<table name>_OwnerID")

OwnerID value from the login table that applies to <table name> table.

SESSION("UserName")

Logged user name displayed in the Logged as <> phrase.

Variable name

Description

SESSION("<table name>_search")

0 - show all records

1 - basic search

2 - advanced search

SESSION("<table name>_searchfield")

Basic search field

SESSION("<table name>_searchoption")

Basic search option (Equals, Contains, etc)

SESSION("<table name>_searchfor")

Basic search for phrase

SESSION("<table name>_pagenumber")

Current page number

SESSION("<table name>_asearchnot")

Advanced search - array with NOT option value for each field

SESSION("<table name>_asearchopt")

Advanced search - array with search option value for each field (Equals, Contains etc)

SESSION("<table name>_asearchfor")

Advanced search - array with with search for value for each field

SESSION("<table name>_asearchfor2")

Advanced search - array with with second search for value for each field (Between search)

SESSION("<table name>_asearchfortype")

AND or OR search

SESSION("<table name>_mastertable")

Master table name

SESSION("<table name>_masterkey1"),

SESSION("<table name>_masterkey2") etc

Master table foreign key values

SESSION("<table name>_orderby")

Order by clause (aFieldName or dFieldName). "a" means ascending, "d" means descending sort order.

SESSION("<table name>_pagesize")

Number of records per page. Readonly.

If you need to change page size programmatically add the following code to After table initialized event:

SESSION("<table name>_sql")

SQL query without WHERE and ORDER BY. Populated on the list page to be used on Print/Export pages.

SESSION("<table name>_where")

WHERE clause. Populated on the list page to be used on Print/Export pages.

SESSION("<table name>_order")

ORDER By clause ("Order by make asc"). Populated on the list page to be used on Print/Export pages.

SESSION("BackURL")

URL to return after password was changed

SESSION("<table name>_SelectedSQL")

Export page - SQL query when page is in "export selected" mode

SESSION("<table name>_SelectedWhere")

Export page - WHERE clause when page is in "export selected" mode