Hello, all - Win XP, Dreamweaver 8.0.2, ASP VBScript,
Microsoft SQL Server
I am working on revising our "Clients Only" area for our
corporate website and have a question regarding our login
validation parameters.
Currently our login validates clients by their "Client ID"
which is stored in an in-house call tracking system database. This
Client ID has spaces within it, requiring our clients to remember
where the spaces are, and if they don't enter it correctly, they
aren't validated (this is an old login developed by a previous
webmaster). This can cause headaches for our clients which I want
to eliminate.
Ideally I would love to be able to put instructions on the
login page that says "Do not use spaces" - so, to that end, I'm
starting here to see if anyone has suggestions on how to strip out
the spaces of the Client ID when validating.
As an example, a Client ID might look like this in the
database: HA B98 7845. The client needs to enter it exactly as
shown or they can't gain access to the area. I'd LOVE for them to
be able to enter HAB987845 and be validated. I've searched this
forum and I've seen reference to a "VBScript Replace function".
While this may not be the answer, I think it may be close.
I should add that the Client ID data in the database cannot
be changed (which would be the easiest solution), I'm looking for a
way that the login ignores the spaces in the Client ID and
validates.