<%
Response.Expires = 0
Response.ExpiresAbsolute = Now() - 1
Response.AddHeader "pragma", "no-cache"
Response.AddHeader "cache-control", "private, no-cache, no-store, must-revalidate"
%>
<%
If Not IsLoggedIn And Request.Cookies(ewProjectName)("autologin") = "autologin" And Request.Cookies(ewProjectName)("password") <> "" Then Response.Redirect "login.asp"
Call LoadUserLevel()
If IsLoggedIn Then
ewCurSec = CurrentUserLevelPriv("UserLevelPermissions")
Else
ewCurSec = GetAnonymousPriv("UserLevelPermissions")
End If
If (ewCurSec And ewAllowView) <> ewAllowView Then Response.Redirect "UserLevelPermissionslist.asp"
%>
<%
' Initialize common variables
x_UserLevelID = Null: ox_UserLevelID = Null: z_UserLevelID = Null
x_TableName = Null: ox_TableName = Null: z_TableName = Null
x_Permission = Null: ox_Permission = Null: z_Permission = Null
%>
<%
Response.Buffer = True
x_UserLevelID = Request.QueryString("UserLevelID")
If x_UserLevelID = "" Or IsNull(x_UserLevelID) Then Response.Redirect "UserLevelPermissionslist.asp"
x_TableName = Request.QueryString("TableName")
If x_TableName = "" Or IsNull(x_TableName) Then Response.Redirect "UserLevelPermissionslist.asp"
' Get action
sAction = Request.Form("a_view")
If sAction = "" Or IsNull(sAction) Then
sAction = "I" ' Display with input box
End If
' Open connection to the database
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open xDb_Conn_Str
Select Case sAction
Case "I": ' Get a record to display
If Not LoadData() Then ' Load Record based on key
Session(ewSessionMessage) = "No records found"
conn.Close ' Close Connection
Set conn = Nothing
Response.Clear
Response.Redirect "UserLevelPermissionslist.asp"
End If
End Select
%>
View TABLE: User Level Permissions
Back to List
<% If (ewCurSec And ewAllowEdit) = ewAllowEdit Then %>
">Edit
<% End If %>
<% If (ewCurSec And ewAllowAdd) = ewAllowAdd Then %>
">Copy
<% End If %>
<% If (ewCurSec And ewAllowDelete) = ewAllowDelete Then %>
">Delete
<% End If %>
<%
conn.Close ' Close Connection
Set conn = Nothing
%>
<%
'-------------------------------------------------------------------------------
' Function LoadData
' - Load Data based on Key Value
' - Variables setup: field variables
Function LoadData()
Dim rs, sSql, sFilter
sFilter = ewSqlKeyWhere
If Not IsNumeric(x_UserLevelID) Then
LoadData = False
Exit Function
End If
sFilter = Replace(sFilter, "@UserLevelID", AdjustSql(x_UserLevelID)) ' Replace key value
sFilter = Replace(sFilter, "@TableName", AdjustSql(x_TableName)) ' Replace key value
sSql = ewBuildSql(ewSqlSelect, ewSqlWhere, ewSqlGroupBy, ewSqlHaving, ewSqlOrderBy, sFilter, "")
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sSql, conn
If rs.Eof Then
LoadData = False
Else
LoadData = True
rs.MoveFirst
' Get the field contents
x_UserLevelID = rs("UserLevelID")
x_TableName = rs("TableName")
x_Permission = rs("Permission")
End If
rs.Close
Set rs = Nothing
End Function
%>