Solved

ASP classic to Visual Studio 2005.

Posted on 2007-03-26
2
295 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 500 total points
Comment Utility
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
Comment Utility
In what file should this file be declared in visual studio 2005.
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
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…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

763 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now