?
Solved

ASP classic to Visual Studio 2005.

Posted on 2007-03-26
2
Medium Priority
?
326 Views
Last Modified: 2013-11-26
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_ID]"
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;Password=[PASSWORD];Persist Security Info=True;User ID=[USERNAME];Initial Catalog=[DATABASE_NAME];Data 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_PERIOD = "select merch_year, merch_period, max(calendar_date) as week_date from calendar_date where convert(varchar,merch_year) + right('00'+convert(varchar,merch_period),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]_Sales_Integrity_"

CONST LOG_FILE = "SL0005"

CONST REPORT_PATH = "\\MtlDEVweb2\report2web\finance\Inventory_control\[REPLACE_DIVISION]-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.sql"
CONST SQL_FILE_SELECT_PERIOD = "scripts\SelectPeriod.sql"
CONST SQL_FILE_CREATE_TEMP_TABLE = "scripts\CreateTempTable.sql"
CONST SQL_FILE_CREATE_TEMP_TABLE_MW = "scripts\CreateTempTableMW.sql"
CONST SQL_FILE_MW_SL_COMPONENT = "scripts\SelectMWSLComponent.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"


%>
0
Comment
Question by:mathieu_cupryk
2 Comments
 
LVL 6

Accepted Solution

by:
Jon_Raymond earned 1500 total points
ID: 18796817
Constants should only require adding type declareations:

CONST PAGE_TITLE_F as string = "Rapport d'intégrité des ventes"
CONST PAGE_TITLE_E as string = "Sales Integrity Report"

CONST DEFAULT_ACTIVE_COMPANY as integer = "5"

etc.
0
 

Author Comment

by:mathieu_cupryk
ID: 18797492
In what file should this file be declared in visual studio 2005.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Kernel Data Recovery is a renowned Data Recovery solution provider which offers wide range of softwares for both enterprise and home users with its cost-effective solutions. Let's have a quick overview of the journey and data recovery tools range he…

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question