mathieu_cupryk
asked on
ASP classic to Visual Studio 2005.
What do I have to do to conform this constant file VB classic to Visual Studio 2005.
<%
response.expires = 0 'don't put this page in the cache
CONST PAGE_TITLE_F = "Rapport d'intégrité des ventes"
CONST PAGE_TITLE_E = "Sales Integrity Report"
CONST APP_SERVER_NAME = "MTLdevDB1\INST2000"
CONST DIVISION_DB_NAME = "PARAM_TWD"
CONST APP_DB_NAME = "GLOBAL_APPS"
CONST REPLACE_USERNAME = "[USERNAME]"
CONST REPLACE_PASSWORD = "[PASSWORD]"
CONST REPLACE_DATABASE_NAME = "[DATABASE_NAME]"
CONST REPLACE_SERVER_NAME = "[SERVER_NAME]"
CONST REPLACE_DIVISION_NAME = "[REPLACE_DIVISION_NAME]"
CONST REPLACE_GENERIC_NAME = "[REPLACE_GENERIC_NAME]"
CONST REPLACE_DIVISION_ID = "[REPLACE_DIVISION_ID]"
CONST REPLACE_REGION_LEVEL_ID = "[REPLACE_REGION_LEVEL_ID] "
CONST REPLACE_DIVISION_LEVEL_ID = "[REPLACE_DIVISION_LEVEL_I D]"
CONST REPLACE_DEPT_LEVEL_ID = "[REPLACE_DEPT_LEVEL_ID]"
CONST REPLACE_CLASS_LEVEL_ID = "[REPLACE_CLASS_LEVEL_ID]"
CONST REPLACE_DEPT_LENGTH = "[REPLACE_DEPT_LENGTH]"
CONST REPLACE_CLASS_LENGTH = "[REPLACE_CLASS_LENGTH]"
CONST REPLACE_WEEK_DATE = "[REPLACE_WEEK_DATE]"
CONST REPLACE_YEAR_PERIOD = "[REPLACE_YEAR_PERIOD]"
CONST REPLACE_BEGIN_DATE = "[REPLACE_BEGIN_DATE]"
CONST REPLACE_END_DATE = "[REPLACE_END_DATE]"
' Connection String ADO générique
CONST CONN_STRING = "Provider=SQLOLEDB.1;Passw ord=[PASSW ORD];Persi st Security Info=True;User ID=[USERNAME];Initial Catalog=[DATABASE_NAME];Da ta Source=[SERVER_NAME]"
CONST DEFAULT_ACTIVE_COMPANY = "5"
CONST DATE_FORMAT = "YYYY/MM/DD"
CONST NBRE_FORMAT = "#,##0"
CONST PCT_FORMAT = "0%"
CONST BASE_FONT_SIZE = 10
CONST TEMP_FOLDER = "tmpdownload\"
'SQLs
Const SQL_GET_CURRENT_YEAR_PERIO D = "select merch_year, merch_period, max(calendar_date) as week_date from calendar_date where convert(varchar,merch_year ) + right('00'+convert(varchar ,merch_per iod),2) = '[REPLACE_YEAR_PERIOD]' group by merch_year, merch_period"
CONST SQL_GET_SELECTED_WEEK = "SELECT calendar_date, merch_year, merch_week, merch_period FROM calendar_date WHERE calendar_date = '[REPLACE_WEEK_DATE]'"
'CONST REPORT_TEMPLATE_E = "SL0005_E.xls"
'CONST REPORT_TEMPLATE_F = "SL0005_F.xls"
CONST REPORT_TEMPLATE_E = "SL0005_E.rpt"
CONST REPORT_TEMPLATE_F = "SL0005_F.rpt"
CONST REPORT_FILE_NAME = "[REPLACE_GENERIC_NAME]_Sa les_Integr ity_"
CONST LOG_FILE = "SL0005"
CONST REPORT_PATH = "\\MtlDEVweb2\report2web\f inance\Inv entory_con trol\[REPL ACE_DIVISI ON]-upload \"
'SQLs
CONST SQL_GET_MERCH_LEVELS = "SELECT DIVISION_ID, CHAIN_LEVEL_ID, REGION_LEVEL_ID, DEPT_LEVEL_ID, SUB_DEPT_LEVEL_ID, CLASS_LEVEL_ID, DEPT_LENGTH, SUB_DEPT_LENGTH, CLASS_LENGTH FROM dbo.MERCH_DIVISION WHERE DIVISION_ID = [REPLACE_DIVISION_ID]"
CONST TMP_TBL_AW_DATA = "#TMP_AW_DATA"
CONST TMP_TBL_MW_DATA = "#TMP_MW_DATA"
CONST TMP_TBL_MA_DATA = "#TMP_MA_DATA"
CONST TMP_TBL_MW_SL_COMPONENT = "#TMP_MW_SL_COMPONENT"
'Scripts
CONST SQL_FILE_DIVISION = "scripts\SelectDivision.sq l"
CONST SQL_FILE_SELECT_PERIOD = "scripts\SelectPeriod.sql"
CONST SQL_FILE_CREATE_TEMP_TABLE = "scripts\CreateTempTable.s ql"
CONST SQL_FILE_CREATE_TEMP_TABLE _MW = "scripts\CreateTempTableMW .sql"
CONST SQL_FILE_MW_SL_COMPONENT = "scripts\SelectMWSLCompone nt.sql"
CONST SQL_FILE_MAIN = "scripts\Main.sql"
CONST SQL_FILE_LOCATION_AW = "scripts\LocationAW.sql"
CONST SQL_FILE_LOCATION_MA = "scripts\LocationMA.sql"
CONST SQL_FILE_LOCATION_MW = "scripts\LocationMW.sql"
%>
<%
response.expires = 0 'don't put this page in the cache
CONST PAGE_TITLE_F = "Rapport d'intégrité des ventes"
CONST PAGE_TITLE_E = "Sales Integrity Report"
CONST APP_SERVER_NAME = "MTLdevDB1\INST2000"
CONST DIVISION_DB_NAME = "PARAM_TWD"
CONST APP_DB_NAME = "GLOBAL_APPS"
CONST REPLACE_USERNAME = "[USERNAME]"
CONST REPLACE_PASSWORD = "[PASSWORD]"
CONST REPLACE_DATABASE_NAME = "[DATABASE_NAME]"
CONST REPLACE_SERVER_NAME = "[SERVER_NAME]"
CONST REPLACE_DIVISION_NAME = "[REPLACE_DIVISION_NAME]"
CONST REPLACE_GENERIC_NAME = "[REPLACE_GENERIC_NAME]"
CONST REPLACE_DIVISION_ID = "[REPLACE_DIVISION_ID]"
CONST REPLACE_REGION_LEVEL_ID = "[REPLACE_REGION_LEVEL_ID]
CONST REPLACE_DIVISION_LEVEL_ID = "[REPLACE_DIVISION_LEVEL_I
CONST REPLACE_DEPT_LEVEL_ID = "[REPLACE_DEPT_LEVEL_ID]"
CONST REPLACE_CLASS_LEVEL_ID = "[REPLACE_CLASS_LEVEL_ID]"
CONST REPLACE_DEPT_LENGTH = "[REPLACE_DEPT_LENGTH]"
CONST REPLACE_CLASS_LENGTH = "[REPLACE_CLASS_LENGTH]"
CONST REPLACE_WEEK_DATE = "[REPLACE_WEEK_DATE]"
CONST REPLACE_YEAR_PERIOD = "[REPLACE_YEAR_PERIOD]"
CONST REPLACE_BEGIN_DATE = "[REPLACE_BEGIN_DATE]"
CONST REPLACE_END_DATE = "[REPLACE_END_DATE]"
' Connection String ADO générique
CONST CONN_STRING = "Provider=SQLOLEDB.1;Passw
CONST DEFAULT_ACTIVE_COMPANY = "5"
CONST DATE_FORMAT = "YYYY/MM/DD"
CONST NBRE_FORMAT = "#,##0"
CONST PCT_FORMAT = "0%"
CONST BASE_FONT_SIZE = 10
CONST TEMP_FOLDER = "tmpdownload\"
'SQLs
Const SQL_GET_CURRENT_YEAR_PERIO
CONST SQL_GET_SELECTED_WEEK = "SELECT calendar_date, merch_year, merch_week, merch_period FROM calendar_date WHERE calendar_date = '[REPLACE_WEEK_DATE]'"
'CONST REPORT_TEMPLATE_E = "SL0005_E.xls"
'CONST REPORT_TEMPLATE_F = "SL0005_F.xls"
CONST REPORT_TEMPLATE_E = "SL0005_E.rpt"
CONST REPORT_TEMPLATE_F = "SL0005_F.rpt"
CONST REPORT_FILE_NAME = "[REPLACE_GENERIC_NAME]_Sa
CONST LOG_FILE = "SL0005"
CONST REPORT_PATH = "\\MtlDEVweb2\report2web\f
'SQLs
CONST SQL_GET_MERCH_LEVELS = "SELECT DIVISION_ID, CHAIN_LEVEL_ID, REGION_LEVEL_ID, DEPT_LEVEL_ID, SUB_DEPT_LEVEL_ID, CLASS_LEVEL_ID, DEPT_LENGTH, SUB_DEPT_LENGTH, CLASS_LENGTH FROM dbo.MERCH_DIVISION WHERE DIVISION_ID = [REPLACE_DIVISION_ID]"
CONST TMP_TBL_AW_DATA = "#TMP_AW_DATA"
CONST TMP_TBL_MW_DATA = "#TMP_MW_DATA"
CONST TMP_TBL_MA_DATA = "#TMP_MA_DATA"
CONST TMP_TBL_MW_SL_COMPONENT = "#TMP_MW_SL_COMPONENT"
'Scripts
CONST SQL_FILE_DIVISION = "scripts\SelectDivision.sq
CONST SQL_FILE_SELECT_PERIOD = "scripts\SelectPeriod.sql"
CONST SQL_FILE_CREATE_TEMP_TABLE
CONST SQL_FILE_CREATE_TEMP_TABLE
CONST SQL_FILE_MW_SL_COMPONENT = "scripts\SelectMWSLCompone
CONST SQL_FILE_MAIN = "scripts\Main.sql"
CONST SQL_FILE_LOCATION_AW = "scripts\LocationAW.sql"
CONST SQL_FILE_LOCATION_MA = "scripts\LocationMA.sql"
CONST SQL_FILE_LOCATION_MW = "scripts\LocationMW.sql"
%>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER