string comparison and increments

[matt ahorn]

on our work registration system we use the first part of the email
address (eg. john.smith) as the username for the registrant, the user
has no choice of username.

When a user register I want to determine if the username already exists
in the db and if it does, modify the username so it will be unique.
I want to modify the username by adding a number on the end. How do I do
this?
note: There are a number of domains in use at work so cannot always
guarentee username uniqueness

I was thinking i would have something like:

varEmailUserName = request.form(FirstPartOfEmailAddress)
varEmailUserName = john.smith 'for example

strsql="SELECT loginid FROM Users WHERE loginid LIKE
'"&varEmailUserName&"'
set rs=conn.Execute(strsql)
If rs.bof and rs.eof then
'unique username will be available
else
'username will exist
'how do i manipulate john.smith to john.smith1
'also john.smith1 must be unique
end if

all help greatfully received
cheers
matt

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[matt ahorn]

Aaron & Ray

cheers for the advice. It's a registration system for intranet
application, it's just that i work for a large company that uses at
least 5 email domains. the actual application locks out accounts after 3
invalid logins, so not too fussed if people know other logins...

cheers
matt



*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!