This is a multi-part message in MIME format.



------=_NextPart_000_0007_01C02554.3EAD4FC0

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



When a new user creates a new username, how do I check if that username 

is already in the database, and if it is, then send a message back to 

the user to select a new username? 



I'm using ASP/HTML/VBSCRIPT/ACCESS



Thanks in advance.

a) Get the username from the form.



b) SELECT pk_ID

FROM Users

WHERE Username = '" & strUserName & "'"



c) If objRS.EOF and objRS.BOF then

        ' there is no matching username

    Else

        ' the username already exists

    End if



    objRS.close

    Set objRS = nothing



HTH



Cheers

Ken





----- Original Message -----

From: "Michael Goldman" <mg188@h...>

To: "ASP Databases" <asp_databases@p...>

Sent: Sunday, September 24, 2000 4:48 AM

Subject: [asp_databases] username lookup





When a new user creates a new username, how do I check if that username is

already in the database, and if it is, then send a message back to the user

to select a new username?



I'm using ASP/HTML/VBSCRIPT/ACCESS



Thanks in advance.