Solved

ASP classic to Visual Studio 2005.

Posted on 2007-03-26
2
308 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
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

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

772 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