Avoiding Duplicate Records

[chc325]

Dreamweaver can prevent duplicate usernames from being inserted into a SQL table. I would like to use UltraDev or MX to prevent duplicate numbers from being upodated. How can I do this in Dreamweaver or by writing custom code (vbscript) Help. Thanks

[Bullschmidt]

Or check to see if the database already contains the entry:

' If not empty rs.
If Not objRS.EOF Then
[Already a user with that name code goes here]
Else
[Process the data code goes here]
End If