Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
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
%>