Hello, thanks for the code it really works!
Actually I´m using SQL Server 2000 and it is possible to register the users with the same user name, and there is not any message that indicate the user exists in the date base. Could you please help me with this!!
'// ATTENTION: this should be changed depending on the database provider
If Err.Number = -2147467259 Then
strError = "- That username is already in use. Please choose another<br>" & vbNewLine
ElseIf Err.Number <> 0 Then
strError = "- An error occured. " & Err.Number & " : " & _
Err.Description & "<br>" & vbNewLine
Else
'record created... redirect
Response.Redirect "login.asp?msg=" & Server.URLEncode("Thank you for registering")
Response.End
End If
Thanks!!