<% '===================================================== ' CONFIG FILE '===================================================== %> <% ' -- VARIABLE DEFINITION ------------------------------ Dim OraSession, OraDatabase ' DB connection Dim QUERIES_PATH Dim SCRIPT_NAME Dim APP_ROOT ' ----------------------------------------------------- %> <% ' -- DATABASE CONNECTIONS ----------------------------- 'Set OraSession = CreateObject("OracleInProcServer.XOraSession") 'OraSession.CreateDatabasePool 1,10,100, Application("TNS_NAME"), Application("ACCESS_MANAGER_LOGIN"), 0 'Set OraDatabase = OraSession.GetDatabaseFromPool(10) Set OraSession = CreateObject("OracleInProcServer.XOraSession") Set OraDatabase = OraSession.OpenDatabase( Application("TNS_NAME"), Application("ACCESS_MANAGER_LOGIN"), Cint(0)) ' ----------------------------------------------------- %> <% ' -- CONFIGURATIONS ----------------------------------- APP_ROOT = Server.MapPath(".") Const APPLICATION_ID = 9 ' Stored in Access Manager, [APPLICATIONS] table QUERIES_PATH = APP_ROOT &"\queries" Const ADMIN_EMAIL = "VixIT@vixtechnology.com" ' ----------------------------------------------------- %> <% ' -- VARIABLE INITIALISATION -------------------------- SCRIPT_NAME = Mid(Request.ServerVariables("SCRIPT_NAME"), InStrRev(Request.ServerVariables("SCRIPT_NAME"), "/") + 1 ) ' ----------------------------------------------------- %> <% ' -- CONSTANTS ---------------------------------------- Const enumDB_DEFAULT_EMPTY = -1 Const enumDB_YES = "Y" Const enumDB_NO = "N" Const enumCOOKIE_NAME = "ACCESS_MANAGER" Const SPACER = "" ' ----------------------------------------------------- %> <% ' -- OO4O --------------------------------------------- const ORATYPE_VARCHAR2 = 1 const ORATYPE_NUMBER = 2 const ORATYPE_SINT = 3 const ORATYPE_FLOAT = 4 const ORATYPE_STRING = 5 const ORATYPE_VARCHAR = 9 const ORATYPE_DATE = 12 const ORATYPE_UINT = 68 const ORATYPE_RAW = 95 const ORATYPE_CHAR = 96 const ORATYPE_CHARZ = 97 const ORATYPE_MLSLABEL = 105 const ORATYPE_OBJECT = 108 const ORATYPE_REF = 110 const ORATYPE_CLOB = 112 const ORATYPE_BLOB = 113 const ORATYPE_BFILE = 114 const ORATYPE_VARRAY = 247 const ORATYPE_TABLE = 248 const ORAPARM_INPUT=1 const ORAPARM_OUTPUT=2 const ORAPARM_BOTH=3 const ORADYN_DEFAULT=&H0& ' ----------------------------------------------------- %> <% ' -- ERROR MESSAGES ----------------------------------- ' ----------------------------------------------------- %> <% ' -- ICONS -------------------------------------------- ' -- ICONS SMALL -------------------------------------- ' ----------------------------------------------------- %>