Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Discussions (General)
 performance 3.4.03 change certain dim to const?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

bjlt
Senior Member

1144 Posts

Posted - 30 October 2002 :  07:33:57  Show Profile
in config.asp

dim strDBType, strConnString, strTablePrefix, strMemberTablePrefix, strFilterTablePrefix

These could be set as const

'const strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'const strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
......

also strUniqueID is a const.

pweighill
Junior Member

United Kingdom
453 Posts

Posted - 30 October 2002 :  08:17:11  Show Profile
You can't join two strings together to form a const or use functions either

const strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb")
Go to Top of Page

bjlt
Senior Member

1144 Posts

Posted - 30 October 2002 :  08:23:10  Show Profile
ah, sorry, I use the hardcoded connstring.

the other four could be changed, right?

'const strDBType = "sqlserver"
const strDBType = "access"
'const strDBType = "mysql"

const strTablePrefix = "_"
const strMemberTablePrefix = "_"
const strFilterTablePrefix = "_" 'used for BADWORDS and NAMEFILTER tables

Edited by - bjlt on 30 October 2002 08:26:14
Go to Top of Page

Deleted
deleted

4116 Posts

Posted - 30 October 2002 :  09:18:21  Show Profile
quote:
Originally posted by bjlt

ah, sorry, I use the hardcoded connstring.

the other four could be changed, right?

'const strDBType = "sqlserver"
const strDBType = "access"
'const strDBType = "mysql"

const strTablePrefix = "_"
const strMemberTablePrefix = "_"
const strFilterTablePrefix = "_" 'used for BADWORDS and NAMEFILTER tables



These are already taken care of in v4b04...

Stop the WAR!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000 Version 3.4.07