Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

ASP classic to Visual Studio 2005.

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

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

789 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