| 2 |
rsolanki |
1 |
<%
|
|
|
2 |
'=====================================================
|
|
|
3 |
' CONFIG FILE
|
|
|
4 |
'=====================================================
|
|
|
5 |
%>
|
|
|
6 |
<%
|
|
|
7 |
' -- VARIABLE DEFINITION ------------------------------
|
|
|
8 |
Dim OraSession, OraDatabase ' DB connection
|
|
|
9 |
Dim QUERIES_PATH
|
|
|
10 |
Dim SCRIPT_NAME
|
|
|
11 |
Dim APP_ROOT
|
|
|
12 |
' -----------------------------------------------------
|
|
|
13 |
%>
|
|
|
14 |
<%
|
|
|
15 |
' -- DATABASE CONNECTIONS -----------------------------
|
|
|
16 |
'Set OraSession = CreateObject("OracleInProcServer.XOraSession")
|
|
|
17 |
'OraSession.CreateDatabasePool 1,10,100, Application("TNS_NAME"), Application("ACCESS_MANAGER_LOGIN"), 0
|
|
|
18 |
'Set OraDatabase = OraSession.GetDatabaseFromPool(10)
|
|
|
19 |
|
|
|
20 |
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
|
|
|
21 |
Set OraDatabase = OraSession.OpenDatabase( Application("TNS_NAME"), Application("ACCESS_MANAGER_LOGIN"), Cint(0))
|
|
|
22 |
|
|
|
23 |
' -----------------------------------------------------
|
|
|
24 |
%>
|
|
|
25 |
<%
|
|
|
26 |
' -- CONFIGURATIONS -----------------------------------
|
|
|
27 |
APP_ROOT = Server.MapPath(".")
|
|
|
28 |
Const APPLICATION_ID = 9 ' Stored in Access Manager, [APPLICATIONS] table
|
|
|
29 |
QUERIES_PATH = APP_ROOT &"\queries"
|
| 3943 |
dpurdie |
30 |
Const ADMIN_EMAIL = "VixIT@vixtechnology.com"
|
| 5299 |
dpurdie |
31 |
Const enumDB_PERMISSION_TYPE_VISIBLE = 1 ' Stored in Access Manager, [Permission_Types] table
|
|
|
32 |
Const enumDB_PERMISSION_TYPE_ACTIVE = 2 ' Stored in Access Manager, [Permission_Types] table
|
| 2 |
rsolanki |
33 |
' -----------------------------------------------------
|
|
|
34 |
%>
|
|
|
35 |
<%
|
|
|
36 |
' -- VARIABLE INITIALISATION --------------------------
|
|
|
37 |
SCRIPT_NAME = Mid(Request.ServerVariables("SCRIPT_NAME"), InStrRev(Request.ServerVariables("SCRIPT_NAME"), "/") + 1 )
|
|
|
38 |
' -----------------------------------------------------
|
|
|
39 |
%>
|
|
|
40 |
<%
|
|
|
41 |
' -- CONSTANTS ----------------------------------------
|
|
|
42 |
Const enumDB_DEFAULT_EMPTY = -1
|
|
|
43 |
Const enumDB_YES = "Y"
|
|
|
44 |
Const enumDB_NO = "N"
|
|
|
45 |
Const enumCOOKIE_NAME = "ACCESS_MANAGER"
|
|
|
46 |
Const SPACER = "<img src='images/spacer.gif' width='1' height='1'>"
|
|
|
47 |
' -----------------------------------------------------
|
|
|
48 |
%>
|
|
|
49 |
<%
|
|
|
50 |
' -- OO4O ---------------------------------------------
|
|
|
51 |
const ORATYPE_VARCHAR2 = 1
|
|
|
52 |
const ORATYPE_NUMBER = 2
|
|
|
53 |
const ORATYPE_SINT = 3
|
|
|
54 |
const ORATYPE_FLOAT = 4
|
|
|
55 |
const ORATYPE_STRING = 5
|
|
|
56 |
const ORATYPE_VARCHAR = 9
|
|
|
57 |
const ORATYPE_DATE = 12
|
|
|
58 |
const ORATYPE_UINT = 68
|
|
|
59 |
const ORATYPE_RAW = 95
|
|
|
60 |
const ORATYPE_CHAR = 96
|
|
|
61 |
const ORATYPE_CHARZ = 97
|
|
|
62 |
const ORATYPE_MLSLABEL = 105
|
|
|
63 |
const ORATYPE_OBJECT = 108
|
|
|
64 |
const ORATYPE_REF = 110
|
|
|
65 |
const ORATYPE_CLOB = 112
|
|
|
66 |
const ORATYPE_BLOB = 113
|
|
|
67 |
const ORATYPE_BFILE = 114
|
|
|
68 |
const ORATYPE_VARRAY = 247
|
|
|
69 |
const ORATYPE_TABLE = 248
|
|
|
70 |
|
|
|
71 |
const ORAPARM_INPUT=1
|
|
|
72 |
const ORAPARM_OUTPUT=2
|
|
|
73 |
const ORAPARM_BOTH=3
|
|
|
74 |
|
|
|
75 |
const ORADYN_DEFAULT=&H0&
|
|
|
76 |
' -----------------------------------------------------
|
|
|
77 |
%>
|
|
|
78 |
<%
|
|
|
79 |
' -- ERROR MESSAGES -----------------------------------
|
|
|
80 |
' -----------------------------------------------------
|
|
|
81 |
%>
|
|
|
82 |
<%
|
|
|
83 |
' -- ICONS --------------------------------------------
|
|
|
84 |
' -- ICONS SMALL --------------------------------------
|
| 5299 |
dpurdie |
85 |
Const LIMG_COMPUTERS = "<img src='images/i_computer.gif' width='11' height='16' hspace='2' border='0' align='absmiddle'>"
|
|
|
86 |
Const LIMG_COMPUTERS_LRG = "<img src='images/i_computer_lrg.gif' width='18' height='18' hspace='2' border='0' align='absmiddle'>"
|
|
|
87 |
Const LIMG_CONTROL = "<img src='images/i_control.gif' width='16' height='16' hspace='2' border='0' align='absmiddle'>"
|
|
|
88 |
Const LIMG_CONTROL_LRG = "<img src='images/i_control_lrg.gif' width='13' height='18' hspace='4' border='0' align='absmiddle'>"
|
|
|
89 |
Const LIMG_DATA_TABLE = "<img src='images/i_data_table.gif' hspace='2' border='0' align='absmiddle' title='See this Control Data Filter (Filter is ON)'>"
|
|
|
90 |
Const LIMG_DATA_TABLE_OFF = "<img src='images/i_data_table_off.gif' hspace='2' border='0' align='absmiddle' title='See this Control Data Filter (Filter is OFF)'>"
|
|
|
91 |
Const LIMG_DISK = "<img src='images/i_disk.gif' width='16' height='16' hspace='4' border='0' align='absmiddle'>"
|
|
|
92 |
Const LIMG_DRILL_DOWN = "<img src='images/i_drill_down.gif' width='12' hspace='2' height='14' border='0'>"
|
|
|
93 |
Const LIMG_EDIT = "<img src='images/i_edit_no_border.gif' width='16' height='16' hspace='2' border='0' align='absmiddle'>"
|
|
|
94 |
Const LIMG_EDIT_OFF = "<img src='images/i_edit_no_border.gif' width='16' height='16' hspace='2' border='0' align='absmiddle' class='lessOpacity'>"
|
|
|
95 |
Const LIMG_LOGOFF = "<img src='icons/i_logoff.gif' width='18' height='18' hspace='2' border='0' align='absmiddle' title='User Logoff'>"
|
|
|
96 |
Const LIMG_LOGON_FAIL = "<img src='icons/i_logon_fail.gif' width='18' height='18' hspace='2' border='0' align='absmiddle' title='User Logon Fail'>"
|
|
|
97 |
Const LIMG_LOGON_SUCCESS = "<img src='icons/i_logon_success.gif' width='18' height='18' hspace='2' border='0' align='absmiddle' title='User Logon Successful'>"
|
|
|
98 |
Const LIMG_REMOVE = "<img src='images/i_remove_no_border.gif' width='16' height='16' hspace='2' border='0' align='absmiddle'>"
|
|
|
99 |
Const LIMG_ROLE = "<img src='images/i_role.gif' width='16' height='16' hspace='2' border='0' align='absmiddle'>"
|
|
|
100 |
Const LIMG_ROLE_LRG = "<img src='images/i_role_lrg.gif' width='13' height='18' hspace='4' border='0' align='absmiddle'>"
|
|
|
101 |
Const LIMG_SESSION_EXPIRE = "<img src='icons/i_session_expire.gif' width='18' height='18' hspace='2' border='0' align='absmiddle' title='Session Timed Out'>"
|
|
|
102 |
Const LIMG_SPEC_ROLE = "<img src='images/i_spec_role.gif' width='16' height='16' hspace='2' border='0' align='absmiddle'>"
|
|
|
103 |
Const LIMG_SPEC_ROLE_LRG = "<img src='images/i_spec_role_lrg.gif' width='13' height='18' hspace='4' border='0' align='absmiddle'>"
|
|
|
104 |
Const LIMG_USER = "<img src='images/i_user.gif' width='16' height='16' hspace='2' border='0' align='absmiddle'>"
|
|
|
105 |
Const LIMG_USER_DISABLED = "<img src='images/i_user_disabled.gif' width='16' height='16' hspace='2' border='0' align='absmiddle'>"
|
|
|
106 |
Const LIMG_USER_DISABLED_LRG = "<img src='images/i_user_disabled_lrg.gif' width='17' height='18' hspace='2' border='0' align='absmiddle'>"
|
|
|
107 |
Const LIMG_USER_LRG = "<img src='images/i_user_lrg.gif' width='13' height='17' hspace='2' border='0' align='absmiddle'>"
|
| 2 |
rsolanki |
108 |
' -----------------------------------------------------
|
|
|
109 |
%>
|