[thelist] trying two passwords in ASP vbscript

[aardvark]

> From: "David Turner" <david.turner at synergy.tv>
[...]
> to allow my sql password to change, i am having to code in the old,
> and then the new password, so i am using an On Error Resume Next line.
> 
> I am not sure if i have done this propertly though, could someone
> advise if there is a neater or a preferred solution.
[...]

use a global variable set in an include file where you establish all 
your constants... then when you upload it, just uncomment the code 
that sets your uid/pwd to the production db and comment out the code 
that sets it to the test db...

if you don't want to have to change it, use the values from the 
server variables request object to determine which to use based on 
the name of the serverdomain name...

that help?

-- 
yet another book:
  The Web Professional's Handbook
  http://roselli.org/adrian/books/handbook.asp
  ISBN: 1904151221